Forum Discussion

hooodoo's avatar
hooodoo
New Member
2 years ago
Solved

Impossible to load an xlsx file from Sharepoint. Getting various errors.

Hi,   I am trying to achieve what, in my opinion, should be a very simple thing - to fetch an xlsx file from Sharepoint and load it into PowerBI. Somehow it doesn't work for me. Here's what I've t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • Mori_mori's avatar
    Mori_mori
    New Member
    1 year ago

    Thank you! I've been failing to connect for so long and it worked with this link!