Forum Discussion
Solved
Error with SharePoint OneDrive folder when switching from Power BI desktop to online
Hi! I have some M code that gets a list of Excel files from a SharePoint OneDrive folder like this: Source = SharePoint.Files("https://company-my.sharepoint.com/personal/myname_company_com", [Ap...
Ok, well it's the same error but on a different query (Query1) this time.
My first guess would be that PQ is picking up a parameter file that's of a different format to the other files in the query. Do you have mixed file types in your source folder and, if you do, what measures have you already taken within the query to exclude these from both the sample file parameter and the transform & combine query?
Pete
Hi TallyReportGuy ,
It looks like a gateway error. Are you pushing this query through your enterprise gateway once it's published to the Service? If you are, you don't need to, so remove this source from your gateway and switch off the 'Use Gateway' switch in dataset settings:
Pete