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 

Shubham_rai955's avatar
Shubham_rai955
Super User
7 months ago

The error means your current Microsoft 365 account does not have OneDrive for Business available/enabled, even though you may have a personal OneDrive.​

Why this happens

  • Power BI / Fabric and Dataverse expect OneDrive for Business (work or school), not a personal OneDrive (Microsoft account like outlook.com, @hotmail.com).​

  • If your tenant or user license does not include OneDrive for Business / SharePoint Online, you get the exact error you quoted when trying to upload/import Excel from the “OneDrive” route.​

Best single fix

Ask your organization’s Microsoft 365 / Office 365 admin to:

  • Confirm your user has a license that includes OneDrive for Business and SharePoint Online (for example, Microsoft 365 Business Standard, E3, etc.), and assign/activate it if missing.​

  • Make sure OneDrive for Business is provisioned for your account (sometimes the license exists but the OneDrive site has never been initialized).​

Until that is fixed, use a workaround that does not require OneDrive for Business, such as:

  • Uploading the Excel file from your local machine directly in the product (e.g., “Upload from this device”), or

  • Saving the file in a SharePoint / OneDrive for Business location owned by someone who does have the correct license and using that account to connect.