Forum Discussion

Kristian71's avatar
Kristian71
Frequent Visitor
1 year ago
Solved

Onedrive Personal to Power Query

It seems like MS have done a change when you want to connect Power BI desktop to an Excel on Onedrive Personal. I have a 365 family subscription and want to connect an Excel on my Onedrive to PBI an...
Need Help
speedramps's avatar
speedramps
Super User
1 year ago

Try this ...

 

In Excel save your file on Onedrive as Excel Workbook (*.xlsx)

 

In Power Bi desktop click  on Get data > Excel workbook

and navigate to the file.  Easy

 

 

If you Publish to PBIX to Power BI Service then you make have an issue, but that was not your question.

You asked how to access an Excel file from Power BI Desktop 

 

  • Kristian71's avatar
    Kristian71
    Frequent Visitor
    1 year ago

    Correct that I did not specifically mentioned pbi service but i did mention i was able to create a connection from the service, my bad.

    So it is all about being able to schedule a refresh in the service up against my personal OneDrive.