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 s...
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.

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.