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. 🙂
Hi lkalawski thanks for replying, I guess what you say is going to have to be probably the implemented workaround I shall have to employ here, but I am wondering why MS have specifically mentioned uploading files to a workspace in the 'Streamlined upload to Power BI' section, seems ludicrous that feature is available only to not be able to then use it as a datasource for a model? There must be a way surely, so I was hoping somebody could tell me how to connect to that excel file uploaded to the PBI service workspace, through even a dataflow configured for it maybe, step by step?
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…!