Forum Discussion
Power BI Dataset Automated Refresh Error
Hello!
I could use some help with the below error
When I do a manual refresh on Desktop, there's no such error; I overrode the dataset thinking that maybe there was something odd with the previous published Dataset but did not work. I also deleted the report and the dataset from the Workspace and got the same result. Any thoughts on what could be causing it? Help will be greatly appreciated
8 Replies
Personal, Shared or Premium workspace?
The dataset is published to a Shared Pro space. I also tested on a personal and same result
And you can confirm that the 'Escalations'[ID] column is not dropped in your Power Query code?
Correct, no name change either from the source which is why is odd that I can refresh just fine from Desktop
Same issue here.
I can see the raw data in SQL but for some reason the connection to the SQL database is not loading.
I have not changed anything in the last 2 weeks in the dataset
I am not sure how this happened but today I opened up the PBIX file in Desktop and upon refreshing manually, I finally got the error the workspace was prompting. I fixed the issue in the query and now it's back to refreshing without issues. You might want to try that same thing with your file and I hope that solves your issue as well. Cheers!
Whether your problem still persist when you refresh the report in Power BI Desktop manually? The problem has been reported to internal team, they are working on it. And the fix for Desktop will release in September version and it will be in about the middle of September. Any comment or problem, please feel free to let me know.
Best Regards
