Datflow Sharepoint folder filter Internal Server Error 500

[ozhug]

When i use a dataflow pointed at a sharepoint site it gets a list of all the files which is working

next step I try and use a filter to narrow down the list to just excel files and get an error 
any ideas how to fix this.

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)

My code is below.

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";

[v-diye-msft]

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:

https://community.powerbi.com/t5/Power-Query/SharePoint-Request-failed-The-remote-server-returned-an... 

[ozhug]

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.

[v-diye-msft]

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:

https://vladtalkstech.com/2015/03/sharepoint-2013-ssrs-remote-server-returned-error-500-internal-ser... 

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.

[ozhug]

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