Error Publishing PBIX

[Gattato]

The following error is posted in the web interface when I publish from Power BI Desktop.

Failed to import data
Do you want to delete the dataset and report?
Please try again later or contact support. If you contact support, please provide these details.
Activity ID47703080-6774-42ac-b6a2-19390e7caed3
Request ID4b74b3d4-2970-667b-34f4-4acf54118cb6
Correlation ID8e3399c4-15ab-9e4c-b80d-d319e76f943d
Status code200
TimeTue Nov 08 2016 14:34:47 GMT-0800 (Pacific Standard Time)
Version13.0.1700.537
Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net

This is a basic data source connected to a SQL server, with no transformations otherwise. How can I troubleshoot and resolve this error?

[v-yulgu-msft]

Hi @Gattato,

Based on my research, I found one possibility that publishing a PBIX file in which measures have the same name as a table to the service will fail. So, did you create any measure that share the same name with any tables. If yes, please rename them and publish the file again.

Besides, what operations did you do in the .pbix file? Did this error always prompt when you publish any .pbix file? If the datasource is not SQL server, can you publish to service successfully?

Thanks,
Yuliana Gu

[alanhodgson]

Hey @Gattato,

Are you running the latest version? I created a connection to our SQL Server (basic query) this morning and had no errors. Also, have you installed and configured a data gateway?

Current version is: 2.40.4554.463 64-bit (October, 2016)

Best,

Alan

[Gattato]

I am running the latest version of Power BI, and I do have a data gateway setup, configured and showing online as well.

[alanhodgson]

@Gattato Double check your data gateway configuration. I have a personal data gateway configured and I just connected to SQL Server and published.

Also, I would hit the "Send Frown" to give feedback to PBI support.

[Gattato]

Thank you. I've done so and it shows it tests successfully. Very frustrating.

I did also "send a frown". Thanks!