cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

OneDrive Refresh (link to .pbix saved in OneDrive/Teams/SharePoint)

I have a .pbix file saved in Teams, so I'm using OneDrive refresh to update the report in the Service when changes are made to the Power BI Desktop file.

 

For an unknown reason, the link has been lost between the dataset saved in my workspace in the Service and the OneDrive location. So any changes made to the .pbix are no longer being reflected in the Service. The OneDrive refresh is failing with a message of "We are unable to locate the file on OneDrive for Business. Please check that the file exists in this location." and the OneDrive refresh toggle is off and can't be turned back on.

 

Is there anyway of re-establishing this connection?

 

The only way I can see to fix the issue is to delete the reprot/dataset from the workspace and republish. But this would mean recreating my Dashboard. I also use Power BI live connection from this data model, so have 30+ other .pbix files reliant on this as a datasource, so I would have to reconfigure all of these too.

 

Any ideas? Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: OneDrive Refresh (link to .pbix saved in OneDrive/Teams/SharePoint)

Hi there

I think once it is lost you have to re-create it all again.

What I would suggest is to use the Shared Datasets functionality in order to make sure other datasets rely on the shared dataset.

I personally have stayed away from the OneDrive method for this reason if something gets lots it has to be re-created.

Here is a blog post by my friend Seth explaining all the details: https://powerbi.tips/2019/09/updating-pbix-files-in-sharepoint-dos-donts/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: OneDrive Refresh (link to .pbix saved in OneDrive/Teams/SharePoint)

Hi there

I think once it is lost you have to re-create it all again.

What I would suggest is to use the Shared Datasets functionality in order to make sure other datasets rely on the shared dataset.

I personally have stayed away from the OneDrive method for this reason if something gets lots it has to be re-created.

Here is a blog post by my friend Seth explaining all the details: https://powerbi.tips/2019/09/updating-pbix-files-in-sharepoint-dos-donts/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Advocate I
Advocate I

Re: OneDrive Refresh (link to .pbix saved in OneDrive/Teams/SharePoint)

Thanks for your reply, and confirming my fear that there was no alternative but to republish!

 

It's a shame that there isn't a way to re-establish the connection, as it's a great feature when a .pbix file is being used in multiple workspaces (i.e. update the file once rather than republishing several times).

 

thanks again...

Highlighted
Super User IV
Super User IV

Re: OneDrive Refresh (link to .pbix saved in OneDrive/Teams/SharePoint)

Hi there

Yeah that was good before Shared datasets, but I would recommend the Shared datasets route going forward.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors