Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, Is there a way I can use my Excel sheet as data from SharePoint online? I know I can connect a SharePoint List which I have done, but I'm having trouble using an Excel file from Sharepoint. Do I use Get Data > SharePoint Folder? I'm not having much luck with that. Thank you
Solved! Go to Solution.
Yes, use the SharePoint Folder option. You'll need to paste in the root URL of the SharePoint site/subsite, not the URL all the way to whatever nested folder you might be using. It'll give you a list of all nested folders and you can filter from there.
Yes, use the SharePoint Folder option. You'll need to paste in the root URL of the SharePoint site/subsite, not the URL all the way to whatever nested folder you might be using. It'll give you a list of all nested folders and you can filter from there.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |