Forum Discussion

Gattato's avatar
Gattato
New Member
9 years ago

Error Publishing PBIX

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?

Need Help

5 Replies

  • alanhodgson's avatar
    alanhodgson
    Solution Supplier
    9 years ago

    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's avatar
      Gattato
      New Member
      9 years ago

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

      • alanhodgson's avatar
        alanhodgson
        Solution Supplier
        9 years ago

        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.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    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