Forum Discussion

keithm's avatar
keithm
New Member
2 years ago
Solved

problem accessing excel file on one drive

hello: I am a new student, I have microsoft 365 business standard, my pc has windows 10. the problem is when I go to one drive thru 365, I see the excel file I uploaded there, I open it in excel c...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi keithm ,

     

    Here are my steps you can follow as a solution:

    1.Obtain the Correct Link from OneDrive:

    • Navigate to your OneDrive for work or school location using a browser. Select the ellipses (...) to open the More menu, then select Details.
    • In the More details pane that appears, select the copy icon next to Path.

     

    2.Use the Copied Link in Power BI Desktop:

    • In Power BI Desktop, select Get data > Web.
    • Paste the copied link into the From Web dialog box.

    3.Authentication:

    • If prompted for credentials, choose Organizational Account. This is crucial for Microsoft 365 or OneDrive for work or school sites.
    • After entering your credentials, you should be able to access the Excel file.

     

    For more details, please refer: Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards,

    Neeko Tang

    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 keithm ,

 

Here are my steps you can follow as a solution:

1.Obtain the Correct Link from OneDrive:

  • Navigate to your OneDrive for work or school location using a browser. Select the ellipses (...) to open the More menu, then select Details.
  • In the More details pane that appears, select the copy icon next to Path.

 

2.Use the Copied Link in Power BI Desktop:

  • In Power BI Desktop, select Get data > Web.
  • Paste the copied link into the From Web dialog box.

3.Authentication:

  • If prompted for credentials, choose Organizational Account. This is crucial for Microsoft 365 or OneDrive for work or school sites.
  • After entering your credentials, you should be able to access the Excel file.

 

For more details, please refer: Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

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