Issues
CompletedUnable to Publish or upload Get Data when Measure has the same name as a Table
Mike Honey on 05 Nov 2016 06:26:43
Myself and others are getting a "error: (404) Not Found" when publishing an unchanged model from PBI Desktop.
This issue seems to the be app.powerbi.com version of the issue reported a few days ago for PBI Desktop:
https://ideas.powerbi.com/forums/360879-issues/suggestions/16893475-unable-to-open-document-we-weren-t-able-to-restor
While the PBI Desktop issue appears to be resolved by the latest build, myself and others are unable to publish:
http://community.powerbi.com/t5/Desktop/After-upgrading-to-Oct-30-2016-I-cannot-refresh-my-model-anymore/m-p/86143/highlight/false#M36125
I also get Status 500 error when using Get Data from app.powerbi.com, e.g.:
We couldn't import data from Power BI Desktop File
The last refresh attempt failed because of an internal service error.
Please try again later or contact support. If you contact support, please provide these details.
Activity IDbd265ad6-bff3-436c-ba58-0c5054afe37b
Request ID65779f80-6b32-f06d-c8ea-e8397947e39b
Correlation ID1645b9bb-ea14-f24a-6f15-56188c1641cb
Status code500
TimeSat Nov 05 2016 10:11:42 GMT+1100 (AUS Eastern Summer Time)
Version13.0.1700.537
Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net
It seems clear the PBI Desktop fix has not been applied to app.powerbi.com.
The trigger seems to be a pre-existing Measure that has the same name as a Table. It seems you do not have to modify the PBIX file to strike this error.
Administrator on 18 Nov 2016 00:51:16
Sorry for the trouble – we had a bug related to reports containing measures with the same name as a table in the model. We’ve since fixed this in Power BI Desktop and the Power BI Service. Please download the latest build of Power BI Desktop from powerbi.com and try again. Thanks for your patience.
- Comments (7)
RE: Unable to Publish or upload Get Data when Measure has the same name as a Table
That fix has been released, and it has resolved this issue for me. Can others please test and post your results.
RE: Unable to Publish or upload Get Data when Measure has the same name as a Table
Same issue here
RE: Unable to Publish or upload Get Data when Measure has the same name as a Table
I notice this fix refers to the issue being when a measure has the same name, i did infact rename my measures and then upgraded to oct 16 version and the service update failed with the above error. can anyone else confirm this happens to them as well?
RE: Unable to Publish or upload Get Data when Measure has the same name as a Table
Thanks all for your votes and comments. The fix for this is now being actively worked on, ref https://powerbi.microsoft.com/en-us/support/
RE: Unable to Publish or upload Get Data when Measure has the same name as a Table
I have same issue but i renamed my tables in Sept release and problem still exists when refreshed with Oct release. internal service error.
RE: Unable to Publish or upload Get Data when Measure has the same name as a Table
Same issue here
RE: Unable to Publish or upload Get Data when Measure has the same name as a Table
Exactly the same is here:
Just create measure with the same name as Table Name and try to upload it from app.powerbi.com.
You will have:
We couldn't import data from Power BI Desktop File
The last refresh attempt failed because of an internal service error.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID856c3c13-54a2-412b-acc7-ba3c732f0151
Request ID84093e08-d3e7-531a-616f-0e9fe8fa21da
Correlation ID13f748ab-594c-b0b1-fb3e-555900a7ad9b
Status code500
TimeSat Nov 05 2016 20:04:37 GMT+0300 (Russia TZ 2 Standard Time)
Version13.0.1700.537
Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net
Then try to upload it from PBI Desktop.
You will have:
error: (404) Not Found
Very useful message :)
The measure example:
Test = sum(Test[Param])
Please HELP!