Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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.
Solved! Go to Solution.
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?
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.
In addition, you can refer to the link below to do a make troubleshooting.
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
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?
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.
In addition, you can refer to the link below to do a make troubleshooting.
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