Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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. ...

Need Help

Anonymous
4 years ago
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.