Who else loves this error:
"Internal Service Error". Vague enough?
For the past few weeks I have been unable to update the dataset. When I publish it from Power BI Desktop, or upload it via the online service, it doesn't seem to replace the old dataset at all. On refresh, the internal service error appears.
So far, Microsoft support has been ineffective on helping with this. We've taken many steps but they don't seem to be tracking with the real problem: It's not an issue with my file or my sources not updating, it is an issue with the service not retaining uploaded datasets.
My only choice at this point would be to upload the file under a different name and completely rebuild the reports, which is not a sustainable solution.
I'll take advice from the community, but I basically want to get this message out that these errors can't continue. Nobody seems to know how to resolve this "internal services error" from all the forums I've looked at.
@jseek Things seem to have escalated to the point where a large number of people are having issues. Tickets have been submitted, MS has acknowledged a problem and is working on it. Support site has it all over the front page: https://powerbi.microsoft.com/en-us/support/
Every Data refresh is a request to the Gateway. Have you tried to look at the logs where the gateway is installed?
in my case, the file is sitting in %LOCALAPPDATA%\Microsoft\Power BI Enterprise Gateway\EnterpriseGateway.log.
1- Have the latest Gateway version
2- Have the latest PBI Desktop version and make sure the model is in line with the underlying data
4- Refresh Data
It never got fixed for me. I have the most recent desktop/gateway versions, and even re-created my data connection settings in desktop before publishing. Everything refreshes and works fine in desktop but it would not let me publish over the existing dataset in the service (even though PBI desktop said it was successfully publishing). I had to delete the dataset from the service and then publish, which works fine, but I lost all the reports/dashboards I had in the service.
Hope you have better luck.