Forum Discussion
Files in PBI Workspace as datasource for Desktop model?
I'm not entirely sure where it stores the files for workspaces, but ASSUMING it's stored in the SharePoint site that is associated with the M365 Group that was created with the workspace, you could connect to it in the SharePoint site. If you're a member of the group, it should show up as a site in your SharePoint site feed (you can click the word "SharePoint" in the top bar of SharePoint to see the sites you're following or are a member of). If it's a single file, I find it easier to download the file, connect to it locally, then change the path reference in Power Query to SharePoint (here's a video on how to do that: https://youtu.be/2HZ8l23RXnc?si=i0eQc7aAzx9a8oi_).
Again, this is assuming it's using SharePoint to store the thing, I never use this feature and always just throw the Excel files in SharePoint so ymmv. 🙂
I'm not entirely sure where it stores the files for workspaces, but ASSUMING it's stored in the SharePoint site that is associated with the M365 Group that was created with the workspace, you could connect to it in the SharePoint site. If you're a member of the group, it should show up as a site in your SharePoint site feed (you can click the word "SharePoint" in the top bar of SharePoint to see the sites you're following or are a member of). If it's a single file, I find it easier to download the file, connect to it locally, then change the path reference in Power Query to SharePoint (here's a video on how to do that: https://youtu.be/2HZ8l23RXnc?si=i0eQc7aAzx9a8oi_).
Again, this is assuming it's using SharePoint to store the thing, I never use this feature and always just throw the Excel files in SharePoint so ymmv. 🙂
Thank you Christine for the handy tip, I am accepting your suggestion as the solution to progress forwards with.
I was hoping to get to the bottom of the PBI service direct file connection issue, but with handy tips as useful as that to employ instead, who cares? Job done, just follow in line and get onto the next objective…!