Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I deposited excel files in a sharepoint folder whose url looks like this: https://mysite.sharepoint.com/sites/Folder1/Folder2/PowerBI
How can I get access to these files?
when I put all the URL in the query I have an error and if I only put https://mysite.sharepoint.com/sites/Folder1, I have too many files and I cannot find mine...
Thank you for your help !
Solved! Go to Solution.
The SharePoint.Files() function, which is what you used, has a 5,000 (or 10,000?) limit to the files it shows.
However, in that source statement - make sure the Power Query formula bar is showing, change it to SharePoint.Contents. This will show you folders, not files. So usually there you click on Shared Documents, then you can drill down to Folder2, then PowerBI. It is much MUCH faster when your site has a lot of files to browse through.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe SharePoint.Files() function, which is what you used, has a 5,000 (or 10,000?) limit to the files it shows.
However, in that source statement - make sure the Power Query formula bar is showing, change it to SharePoint.Contents. This will show you folders, not files. So usually there you click on Shared Documents, then you can drill down to Folder2, then PowerBI. It is much MUCH faster when your site has a lot of files to browse through.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.