Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Inmport excel file

when i try to import a excel file , i get the error "Your account does not have a sufficient license for OneDrive for Business to complete the requested action. Please contact your organization’s Of...
Need Help
  • RangancnFabric's avatar
    RangancnFabric
    7 months ago

    Hi ALL,

    My apalogies for not respondong earlier ...

     @tayloramy , @Zanqueta , @Olufemi7  and @Shubham_rai955  - what worked for me is signing up for Business account and canceling the personal account ... Now it works 

Olufemi7's avatar
Olufemi7
Super User
8 months ago

Hello Anonymous, 
The error you’re seeing is because Power BI is trying to connect to OneDrive for Business, not a personal OneDrive account. Power BI integrates only with OneDrive for Business or SharePoint Online to keep datasets refreshed automatically.

A personal OneDrive (like the one tied to outlook.com or hotmail.com) isn’t supported for this feature.

 How to work around this:

  1. Import the Excel file directly from your computer

    • In Power BI Desktop, go to Home > Get Data > Excel.

    • Browse to the file on your local machine and load it.

    • Then publish the report to the Power BI Service.

    • This avoids the OneDrive for Business requirement.

  2. If you need automatic refresh

    • You’ll need a Microsoft 365 Business or Education license that includes OneDrive for Business.

    • Ask your Office 365 administrator to assign you the correct license.

    • Once you have OneDrive for Business, you can store the Excel file there and connect Power BI directly.

  3. Manual refresh option

    • If you only have personal OneDrive, you can still upload the file there, download it locally, and re-import when needed.

    • You won’t get scheduled refresh, but you can update manually.

Even though you have a personal OneDrive, Power BI requires OneDrive for Business for cloud imports. If you don’t have that license, just import the Excel file locally from your computer instead.