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.
section Section1;
shared Query = let
Source = SharePoint.Files("https://<mywork>.sharepoint.com/sites/FunSite"),
#"Filtered rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx"))
in
#"Filtered rows";
Hi @ozhug
To connect to sharepoint folder in Power BI, please get root url of your SharePoint site and enter the URL in SharePoint Folder connector, see https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/.
Here's another similar threads could be your reference:
Hi @v-diye-msft
connect to sharepoint was ok
when i apply the filter it has a 500 error,
#"Filtered rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx"))
my guess would be that the engine is trying to push this filter to the source and failing.
Hi @ozhug
The 500 (Internal Server Error) status code indicates that the server encountered an unexpected condition that prevented it from fulfilling the request.
It looks like the error may be related to how the server is handling the request.
Kindly filter the rows on the desktop and check whether it works.
Here's a blog could be your reference:
If you still have this issue, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum to get further help.
Hi @v-diye-msft
This blog post asked me to check eventview is that possible with sharepoint online ?
Here's a blog could be your reference: https://vladtalkstech.com/2015/03/sharepoint-2013-ssrs-remote-server-returned-error-500-internal-ser....
thanks
Mark
Covering 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.