Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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?
Solved! Go to 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.
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.