Forum Discussion
SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error.
Hi, My solution had been working fine for months, until 3 days ago when my reports started failing. The datasource is SharePoint Online Lists and I have 4 different reports querying the same Shar...
Team,
My advice for Power BI > Sharepoint Lists
1. Use Odata.Feed (Not default SP connector) and use $SELECT to get only the fields you need
2. If your lists have >500 records, then do not use the field FIELDVALUEASTEXT with expansion as that is a JSON summary field that significantly bloats the RESPONSE payload
3. Make sure that entire M code script runs in under 45 minutes as the AUTHORIZATION token will expire after 60 minutes and you will get wierd "NOT AUTHORIZED" errors
HTH,
Jim
Hi Jim,
I'm getting the same error, but pulling together excel files in a SP folder, doing some transforms and appending... can I also use the OData connector? I've never tried that.
Thanks,
Kim