Forum Discussion
When looking at a Report in a Workspace, how do I know whether it's been Published or Connected?
So, sometimes we Publish reports to a Workspace from Power BI Desktop. And sometimes we do it the alternative way, where we store the pbix files in SharePoint and Connect to them from the Workspace. ...
lbendlin
Super User
Super UserYou are correct, as per this documentation.
Get data from Power BI Desktop files - Power BI | Microsoft Docs
I'll have to try that out.
It's a great way of doing it, but there's a *massive* gotcha. Once you've Connected to a pbix file in SharePoint, you can NEVER delete that file in SharePoint. The link SP --> PBI is sone on teh file ID, not file name, so if you delete it in SP, then re-upload it to SP, you're screwed, it won't connect to the file in the PBI Workspace ever again. This plays havoc with Pipelines etc.
- lbendlin
Yes, at the bare minimum you should enable version history - which may give its own issues if the PBIX is rather large and the quota is rather small.