Error loading shared Sharepoint file

[Anonymous]

Hi, all

I'm trying to connect an Excel file that was shared with my to a PBI report. The file must be the shared one.

When connecting, APIVersion 15 is not working, so I've changed to 14.

But when I click to expand and get the file, it shows this error.

DataSource.Error: SharePoint: Falha na solicitação: O servidor remoto retornou um erro: (500) Erro Interno do Servidor. (An error occurred while processing this request.)
Detalhes:
DataSourceKind=SharePoint
DataSourcePath=https://XXXX-my.sharepoint.com/personal/XXXXX_com/_vti_bin/ListData.svc/SolutionGallery
SPRequestGuid=09a93ea0-d06f-1000-c8dd-df876515fb97
Url=https://XXXXX-my.sharepoint.com/personal/XXXXX_com/_vti_bin/ListData.svc/SolutionGallery

I don't know what to do to solve. COuld you please help?

[Anonymous · Accepted solution]

Hi,

I've found a workaround on this post: https://community.powerbi.com/t5/Power-Query/Sharepoint-file-as-data-source-results-in-error-row-tha...

Solution was to use API version 14 and change SharePoint.Files() to SharePoint.Contents() then navigate the folders until finding the file.

[jennratten]

Here are some posts that may help.

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

https://community.powerbi.com/t5/Desktop/DataSource-Error-SharePoint-Request-failed-The-remote-serve... 

[Anonymous]

Hi @jennratten 

Thanks for the response. I've actually saw these posts but it doesnt seem to work.