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.

AbhinavJoshi's avatar
AbhinavJoshi
Icon for Responsive Resident rankResponsive Resident
2 years ago

Hello hooodoo. When connecting to SharePoint use Micorosoft Account and make sure you are signed in on Power BI as well. Instead of using SharePoint folder as a Source use Web/CSV. Here are the steps.

  1. Navigate to the xlsx file in SharePoint.
  2. Click on Open in Dekstop App.
  3. When in Excel, click info and copy path (make sure it is a web path not a local path to your machine).
  4. Enter the path into the diaglog box of web/csv.
  5. Make sure you remove the ?web=1 from the link. It should only be upto yourfile.xlsx

I hope this helps.

 

Please mark it as a solution if it helped you.

 

Thank you,

Abhinav