Power BI query SharePoint Folder has Error 500 from Server

[Topogigio22]

I am trying to combine Excel files stored in a SharePoint Online folder. My query is successful and returns the exact data I am looking for but also includes a Server error 500 that I can not resolve. I saw old threads here with the same topic but no answers. Does someone know the solution. I can get all of the data from the files but can not successfully complete a refresh or clear the error.

Query
let
Source = SharePoint.Files("http://northamerica.xxx.corp/Operations/DSMOps/OpX/", [ApiVersion = 14]),
#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = "http://northamerica.xxx.corp/Operations/DSMOps/OpX/TrueNorthMetrics/") and ([Extension] = ".xlsx") and ([Name] = "MOSDAppHistoryReport_2021-10-11_14-03-30.xlsx" or [Name] = "MOSDAppHistoryReport_2021-10-18_14-01-17.xlsx"))
in
#"Filtered Rows"

Results

Error
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)
Details:
DataSourceKind=SharePoint
DataSourcePath=http://northamerica.xxx.corp/Operations/DSMOps/OpX/_vti_bin/ListData.svc/Workflows
SPRequestGuid=6f61fb9f-80d7-6091-a61f-da9aa45a44f6
Url=http://northamerica.xxx.corp/Operations/DSMOps/OpX/_vti_bin/ListData.svc/Workflows