cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PhilCamp
Frequent Visitor

Issue opening .pbix file residing on a Sharepoint online site

I had been working on creating a report with Power BI Desktop on my OneDrive.  However, I need colleagues to be able to modify the report so uploaded the .pbix file to a Sharepoint folder.  After a few days, I was no longer able to open the file residing on SharePoint from Power BI Desktop.  I receive an Access Denied error.  I've noticed when hovering over the path of "recent items" a portion has been preceeded with @SSL\DAVWWWRoot and noticed it about the time the access issue started.  I had a similar issue occur with one of my queries, which was pulling data from an Excel file on the same SharePoint site.  For some reason, that same string appeared in the source file path and I could no longer connect to refresh data.  I was able to replace with the correct source path in query editor in that latter.  However, haven't been able to resolve the issue with the actual .pbix file location.  This includes pasting the file name/sharepoint path within the "filename" field of the Open dialogue box.  Any recommendation for resolution?

2 REPLIES 2
Community Support
Community Support

Re: Issue opening .pbix file residing on a Sharepoint online site

Hi @PhilCamp ,

 

Could you please check whether you can access to the site of share point?

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
PhilCamp
Frequent Visitor

Re: Issue opening .pbix file residing on a Sharepoint online site

Yes, I can access the SharePoint site.  It is a project site collection, we've been using for years.  The issue is just with trying to open .pbix file with desktop.  Note: I was able to identify a resolution to "Sync" respective SharePoint folder, which generates a local copy.  I can then open that file with Power BI Desktop and update.  The updates will then sync to the master SharePoint version.  This actually a much better solution for my scenario where I have multiple users who could update the file.  It minimizes simultaneous user update issues, assuming SharePoint handles this in terms of managing synchronization.  I'm surprised this was not more clearly spelled out after searching online for 2-3 days.

Helpful resources

Announcements
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