Forum Discussion

Economech's avatar
Economech
Regular Visitor
5 years ago
Solved

Reading a onedrive excel file

It seems like Power Bi does not have OneDrive in the list of get data which sounds weird. I have got an excel file in my one drive accessible with a unique and global address (URL). How I should set ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Economech ,

     

    Here are the steps you can follow：

    1. Open OneDrive, find the required Excel file, and choose to open it in the APP.

    2. Select the file in Excel, select info, select link, and click copy link to clipboard.

    3. Open Get Data in Desktop and select Web.

     

     4. Remove the ?web=1 string at the end of the link so that Power BI Desktop can properly navigate to your file.

    5. If Power BI Desktop prompts you for credentials.
    For on-premises SharePoint sites, select Windows, for or Microsoft 365 or OneDrive for Business sites, select Organizational AccountSelect the content to be imported and confirm it is complete.

     

     6. Select the content to be imported and confirm it is complete

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
5 years ago

Economech 

 

Open your OneDrive folder using the browser. Then locate your excel file.

Select your file and click 3 dots near that file. Then click details.

Right side, you will get a small box. Scroll down and copy the path. (Click on copy icon near text: Path)

 

Now you can open the Power BI desktop and use the web connector. 

You can choose the authentication type as an Organizational Account.




Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!