Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Connect excel data in One drive as a data source for Power BI

 Hello,   I am trying to connect some excel data stored in One Drive as described in the article attached (https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links). I am getti...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    After test,i t has no issues that I am logging in with different accounts in Power BI and One Drive. But when you get data from OneDrive, you must type OneDrive credentials rather than use your Power BI account, please follow the steps below.

    1. Click File->Options and Settings->Data source settings->clear your previous permission.



    2. In Power BI desktop, type the link, please choose the Organizational Account to sign in(because use OneDrive for business, type your Organizational Account of OneDrive here), it will work fine after clicking connect. In this part, if you use windows authentication, it will return the error message, because you current power BI account is not windowns account.



    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

After test,i t has no issues that I am logging in with different accounts in Power BI and One Drive. But when you get data from OneDrive, you must type OneDrive credentials rather than use your Power BI account, please follow the steps below.

1. Click File->Options and Settings->Data source settings->clear your previous permission.



2. In Power BI desktop, type the link, please choose the Organizational Account to sign in(because use OneDrive for business, type your Organizational Account of OneDrive here), it will work fine after clicking connect. In this part, if you use windows authentication, it will return the error message, because you current power BI account is not windowns account.



Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Many thanks Angelia, now it works properly!