Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Power BI Consistent Refresh failure

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.

7__0-1660146616970.png

Any Idea what would cause this report that was working to suddenly stop updating even though it still works fine in the desktop?

Status: Delivered

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

Comments
v-yetao1-msft
Community Support
Status changed to: Delivered

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