Forum Discussion
Error loading shared Sharepoint file
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?
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-that-cannot/td-p/1305094
Solution was to use API version 14 and change SharePoint.Files() to SharePoint.Contents() then navigate the folders until finding the file.
3 Replies
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-that-cannot/td-p/1305094
Solution was to use API version 14 and change SharePoint.Files() to SharePoint.Contents() then navigate the folders until finding the file.
