I recently upgraded to Power BI Premium so that I could update a report more frequently and set it up on a schedule to update every 30 minutes during the work day. It worked great for a few weeks. However, now it fails the refresh every time. I did not add any new sources to the dataset or anything like that, just one day, it stopped working.
Now the really odd part is that i can still go into Power BI Desktop and update the report there. It updates in a few seconds and I can republish it to same workspace to overwrite the old one and get the update. Of course this requires me doing so manually every time I want to update, which is a huge waste of time and the money I am paying for Power BI Premium.
below is the error I am getting, it says that it will be transient, but it has been happening every time for about a week now.
Any Idea what would cause this report that was working to suddenly stop updating even though it still works fine in the desktop?
As you mentioned you cut out some of the fields that you only use for one visual so that you could slim down the query . But with the growing data in dataset , this situation may be encountered later .
Based on the above information , my suggestion is that next time you encounter this situation, you can open a Support ticket. The limitation of the forum is that we can't trace your log, but this problem can be solved by open support ticket .