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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Syncing published Power BI report files using OneDrive

Hi All,

 

We have a couple of PBI reports being published using OneDrive. Everything was working fine until we changed the dataset owner. Now it looks like the connection is broken somehow:


error.png

 

Dataset owner signed out and back in, but the issue remains, the reports in OneDrive don't get published in PBI Service anymore.

 

Any idea on how we can fix the connection?

 

Thank you.

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

Did you put the pbix file directly on OneDrive? How did you change the owner of the dataset, by going to the dataset setting page and clicking the Take Over button or by REST API Datasets - Take Over In Group? It's worth noting that if you change the owner of the dataset, the new owner needs to reconfigure all the information (credentials of all data sources involved, scheduled refreshes, etc.). Please check if the new owner has access to the pbix files that locate on OneDrive and if the account is expired?

Take over datasetTake over dataset

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.TakeOver

If all the above information is OK, you can try to delete the corresponding report from Power BI Service. Then re-upload the report file by Get Data and check later if the same error is still reported.

yingyinr_0-1643609919345.png

In addition, you can refer to the link below to do a make troubleshooting.

When things go wrong

When you save your changes to the Power BI Desktop file on OneDrive and you don't see those changes in Power BI within an hour or so, it could be because Power BI can't connect to your OneDrive. Try connecting to the file on OneDrive again. If you’re prompted to sign in, make sure you select Keep me signed in. Because Power BI wasn't able to connect to your OneDrive to synchronize with the file, you’ll need to import your file again.


Power BI: Why my report is not refreshing from OneDrive? Compatibility chart for sources.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @v-yiruan-msft


We fixed the issue by deleting and re-uploading the PBI report.

 

Thanks.

v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

Did you put the pbix file directly on OneDrive? How did you change the owner of the dataset, by going to the dataset setting page and clicking the Take Over button or by REST API Datasets - Take Over In Group? It's worth noting that if you change the owner of the dataset, the new owner needs to reconfigure all the information (credentials of all data sources involved, scheduled refreshes, etc.). Please check if the new owner has access to the pbix files that locate on OneDrive and if the account is expired?

Take over datasetTake over dataset

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.TakeOver

If all the above information is OK, you can try to delete the corresponding report from Power BI Service. Then re-upload the report file by Get Data and check later if the same error is still reported.

yingyinr_0-1643609919345.png

In addition, you can refer to the link below to do a make troubleshooting.

When things go wrong

When you save your changes to the Power BI Desktop file on OneDrive and you don't see those changes in Power BI within an hour or so, it could be because Power BI can't connect to your OneDrive. Try connecting to the file on OneDrive again. If you’re prompted to sign in, make sure you select Keep me signed in. Because Power BI wasn't able to connect to your OneDrive to synchronize with the file, you’ll need to import your file again.


Power BI: Why my report is not refreshing from OneDrive? Compatibility chart for sources.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors