Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Power BI Consistent Refresh failure

Submitted by Anonymous on ‎08-10-2022 08:52 AM

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: Done
See more ideas labeled with:
11 Comments (11 New)
Comments
AilsaTaoYe
Regular Visitor
‎08-10-2022 07:36 PM

Hi @Anonymous 

The data you refreshed is dataset or dataflow ? Can you refresh your data in Service manually ? If you can refresh your data manually and successfully , the problem maybe in scheduled refresh configuration , you need change the scheduled refresh settings . If you cannot successfully refresh data manually , you need pay attention to your gateway and data source configuration in Service .

Anonymous
Not applicable
‎08-11-2022 06:40 AM

Thank you @AilsaTaoYe,

 

The data is in a dataset and It is not succedding in a manual refresh through Service either. The Manual refresh only works through the Desktop App. I will take a look at the gateway and data source configuration in Service and how they differ from the Desktop version. 

AilsaTaoYe
Regular Visitor
‎08-11-2022 06:37 PM

Hi @Anonymous 

Fine . If you still have a question about refreshing data , you can update here . 

Anonymous
Not applicable
‎08-12-2022 11:32 AM

Thank you @AilsaTaoYe 

 

It has stopped working updating on the desktop version too. I have tried to update it thorugh the desktop app a few times now and it has crashed my laptop causing it to automatically restart multiple times. I tried refershing the sources one at a time and I identified which one is failing because the other ones all worked fine on their own. However, the one that is failing is from the exact same source as another one that is still working. I may just have to call that report shot and rebuild it from the ground up.

Anonymous
Not applicable
‎08-16-2022 11:45 PM

Hi @Anonymous 

Has your issue been fixed after rebuilding it from the ground up ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎08-17-2022 12:32 PM

Yes @Anonymous,

 

I had to cut out some of the fields that I only use for one visual so that I could slim down the query. So, I was not able to get back 100% of what I had before. I only took the most neccesary fields. However, I did get it to start working again after making a new report with the same data sources filtering out as many fields as possible. I was able to get the new report to update without crashing everything consistently. However, this is a dataset that grows in records daily. So, I am expecting that it will fail again when I get too many records. At that point, I do not know what I will do.

Anonymous
Not applicable
‎08-19-2022 11:56 AM

The same thing is happening with me since 5th august.

 

In my case is a small dataset with two API connections, I never got this type of error.

 

A few days ago I could refresh my dataset from Power BI Desktot but recently I can't, my notebook was restarted a couple of times because memory problems.

 

I tried take out some columns but my dataset is really small, the automatic refresh before this problem was really fast.

Someone help me!!!

Anonymous
Not applicable
‎08-23-2022 02:16 AM

Hi @Anonymous 

What is your data source ? 

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎08-23-2022 06:46 AM

@Anonymous I am using a web connector to the backend of our ticketing system.

 

@Anonymous That is about the same time mine started failing. After that Power BI started acting up quite a bit actually.

Anonymous
Not applicable
‎08-23-2022 10:57 AM

@Anonymous, 

 

I managed to solve the problem by changing the way to get the data.

 

I was using the function Xml.Tables to get data from the API, instead Xml.Tables, I used the function to get data in JSON format in Power Query.

 

After that I've republished my report.

 

My dataset was updated with no problems in Power BI Desktop and Service.

Idea Statuses