Forum Discussion

prmutha's avatar
prmutha
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Dataset refresh fails due to internal server error in PowerBI App, but refreshes in Desktop

Hello there,

I have dataset that refreshes on a schedule. It has failed multiple times with the following information:

Something went wrong

The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

Please try again later or contact support. If you contact support, please provide these details.


Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: a809c42d-74f0-3dab-1211-945cf22b04c8
Request ID: 58985587-c098-3aef-6c50-f00b85a653c0
Time: 2022-06-02 20:11:09Z

How can I investigate further to know what is the exact issue and how to fix it. Where can I look for the above diagnostic information?

Need Help
  • prmutha's avatar
    prmutha
    4 years ago

    Thank you for your response!
    The datasource is in the could, so gateway is not needed. I did test the Data Source Credentails on the dataset and it succeeded.

    After searching for "FailedToRefreshPackageAfterImportError" in the powerbi community, I saw some solutions to rename dataset and delete, re-create and publish.

    So, I renamed and published and tested the on-demand dataset refresh. It refreshed successfully. So, I'll close the ticket now.

4 Replies

  • prmutha's avatar
    prmutha
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    I captured a Fiddler trace when publishing from PBI desktop. The dialog in PBI desktop has the following message:

    The fiddler trace has following error info:
    code=FailedToRefreshPackageAfterImportError
    message={"error":{"code":"CouldNotResolveSemanticQueryDefinition"....}}

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      4 years ago

      Hi prmutha 

       

      Can you check to make sure that the gateway can connect successfully to the data source?

       

      Also sometimes there is some issue in the Power BI Service and it auto resolves itself.

  • AndreasSteinweg's avatar
    AndreasSteinweg
    New Member
    3 years ago

    In my case I have had an SQL statement that I just inserted into "Blanc Query". In preview mode everything worked and looked good. but when I hit "Save & Close", I got the message, tha something went wrong... . 

    I solved the problem by taking the "SQL Database" object instead od "Blank Query". I expect that Power BI did not know which driver to take, when I hit "Save & Close". The error was just confusing me, because it worked in preview mode.   

  • prmutha's avatar
    prmutha
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Thank you for your response!
    The datasource is in the could, so gateway is not needed. I did test the Data Source Credentails on the dataset and it succeeded.

    After searching for "FailedToRefreshPackageAfterImportError" in the powerbi community, I saw some solutions to rename dataset and delete, re-create and publish.

    So, I renamed and published and tested the on-demand dataset refresh. It refreshed successfully. So, I'll close the ticket now.