Forum Discussion
Impossible to load an xlsx file from Sharepoint. Getting various errors.
Hi hooodoo ,
After my test, you can try this way:
Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn
Files in Sharepoint and Onedrive should be interoperable.
Open Onedrive > My files > Find the .xlsx file which you want connect to:Find details:
Copy path in the right-hand pop-up bar:
In Power BI Desktop, Get Data > Web:
Paste in the link you just copied, select Organizational Accounts to authenticate with the account you use to log in to SharePoint:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi hooodoo ,
After my test, you can try this way:
Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn
Files in Sharepoint and Onedrive should be interoperable.
Open Onedrive > My files > Find the .xlsx file which you want connect to:
Find details:
Copy path in the right-hand pop-up bar:
In Power BI Desktop, Get Data > Web:
Paste in the link you just copied, select Organizational Accounts to authenticate with the account you use to log in to SharePoint:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! I've been failing to connect for so long and it worked with this link!