Power BI Consistent Refresh failure

[7_]

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?

[v-yetao1-msft]

Hi @7_ 

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 .

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Best Regards,
Community Support Team _ Ailsa Tao