Forum Discussion
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...
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
Hello Anonymous,
This error occurs because Power BI, when attempting to import an Excel file, uses integration with OneDrive for Business to maintain the connection and enable automatic refresh. Having a personal OneDrive account is not sufficient. Your account must have a valid licence for OneDrive for Business, which is included in Microsoft 365 organisational plans.
How to resolve this
There are two options:
1. Confirm your licence with the administrator
- Check with your Office 365 administrator whether your account has a licence that includes OneDrive for Business (for example, Microsoft 365 Business, E3, or E5).
- If not, an appropriate licence will need to be assigned.
2. Alternative without OneDrive
- Instead of using Import from OneDrive, upload the file directly:
- In Power BI Service, go to Get Data > Files > Local File.
- This uploads the file to the service, but does not maintain automatic synchronisation.
Official reference:
Get data from Excel workbook files - Power BI | Microsoft Learn
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
will try this and keep you posted ..