Showing results for 
Search instead for 
Did you mean: 
ArupC Advocate II
Advocate II

Dataset not refreshing from One Drive

I had created dataset in Power BI Service through a powerpivot file is stored in One Drive (Personal).

This dataset used to get refreshes automatically whenever file in one-drive is updated (there was no issues for past 6 months).

Today it is showing that dataset refresh is failed. Msg shows that gateway is offline but as I understand, personal gateway is not required if file not created with PowerQuery that connects to another source. 

My file is Excel Powerpivot file which is created from normal excel/csv as data source and i sync that file to one drive.

Why this has happened suddenly contary to documentation. What is the solution. Pls advise.




Super User IV
Super User IV

Re: Dataset not refreshing from One Drive

You probably want to send a frowny face to support (smiley icon in upper right). Include a screen shot and the description above. There is a decent possibility that a bug or something else was introduced in a recent revision to the service. Support should be able to get to the bottom of it.


Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

spiderrob Advocate III
Advocate III

Re: Dataset not refreshing from One Drive

You need to log a ticket - I'm also seeing an issue but with a pbix file that is on one drive. Worked fine for months and now it shows as an error - however if you force the manual refresh it then works. Changes to files on one drive should be picked up hourly.


There was a service issue with one drive groups recently - maybe the fix has caused others.. I have an open ticket on O365.

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors