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. 🙂
Hello MeadowDec ,
You could try this solution https://youtu.be/CKGyf3NWAd8?si=J8-_2WWmlPIWLuUx
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Hi Idrissshatila thanks for replying, but that does not help, in that tutorial she is connecting to onedrive it looks like to create a dataset from within the service.
Whereas I want to connect to a file uploaded to the service from within Desktop.