Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Someone has placed excel files in the SharePoint "Site Assets" library, for example "https://company.sharepoint.com/sites/department/SiteAssets/SitePages/TeamFolder/Data.xlsx"
This isn't where files should be stored, but that's where they are and I need to connect to the data in the excel file. But when connecting to the SharePoint site from Power BI it doesn't include this library, all files from other parts of the site appear but not from Site Assets.
Before I go back to them and re-arrange their file locations, I'd like to know if I'm missing something and is there a way to connect to the files in this Site Assets?
Solved! Go to Solution.
Remember that you can substitute SharePoint.Files for SharePoint.Contents which gives you full visibility (at the cost of manual navigation)
Remember that you can substitute SharePoint.Files for SharePoint.Contents which gives you full visibility (at the cost of manual navigation)
Use sharePoint Folder or web in get data
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |