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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
chudson
Helper IV
Helper IV

Power BI Online Service Data Refresh Time Out Error

 

Hi,

 

I have multiple datasets that refreshed correctly today but one that keeps getting a time out error.  I've also tried to re-publish using the .PBIX file but that isn't working either.  Today is the first time with this dataset I'm having issues as you can see it normally refreshed during the schedule refresh very quickly.  Does anyone know what the issue is and how to resolve?  I've tried to submit a support ticket but there seems to be an issue with that as it says I'm not logged in as Pro user.

 

chudson_0-1615920881618.png

 

 

chudson_1-1615920637419.png

 

chudson_2-1615920660821.png

 

 

 

Thanks,

Chris

5 REPLIES 5
chudson
Helper IV
Helper IV

Hi @aj1973 

Where would the admin fix in the dataset or look?  I also published the same dataset to another workspace and it published and refreshed fine so I'm not sure why this one specific one is not refreshing.

 

Hi @NimaiAhluwalia 

I'm do not need a gateway as all my datasets are on the cloud.  I'll try refreshing again to see but I'm not sure why this one is having issues as all my others are refreshing very quickly that are even larger datasets.

 

 

Thanks,

Chris

 

Hello @chudson 

 

As I said before, check the load of the database at the time of making the refresh, because the error shows that the issue is with the size and that is due to an excess of tables and columns.

 

The other best suggestion I can provide is not to refresh the tables which are not required to be and also reduce the columns or the tables that are not required in the dataset 

 

IF MY SOLUTION HELPED YOU IN SOME OR THE OTHER WAY PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT RESOLVES FOR ERROR!

Hi @NimaiAhluwalia & All,

 

I was working with the Microsoft support team and they let me know they think the Power BI service was being effected by some world wide Azure Active Directory outages occuring over the last few days.  It should be resolved but I will be monitoring the next few days. 

 

Like I show above, this refresh normally takes 2-10 minutes in the serivce over the last few years and all of sudden it started taking over 2 hours and timing out without any data or modeling changes on our end.

 

 

Thanks,

Chris

NimaiAhluwalia
Responsive Resident
Responsive Resident

Hello @chudson 

 

We generally get this type of time out error when we have passed the maximum limit of the refresh or the source is taking to much time to respond because it has a load in the backend form other services also for the retrieval so try triggering the refresh at a time when the source is free.

 

If the data source is on-premise try configuring the gateway again it helps most of the times.

 

IF MY SOLUTION HELPED YOU IN SOME OR THE OTHER WAY PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT RESOLVES FOR ERROR!

aj1973
Community Champion
Community Champion

Hi @chudson 

You have a capacity problem with the dataset, Check with your administrator for a Fix.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.