Forum Discussion
Error connection to Excel file on OneDrive
- 1 year ago
HI gdenayer ,
Thank you for reaching Microsoft Community.
As per the information provided by you,It looks like an issue with authentication or access rights, particularly around SharePoint/OneDrive and how Power BI tries to verify your identity.
Check the File permissions, ensure that Excel file is shared correctly and that your Power BI account has read access to the file, also If using OneDrive, make sure you're signed into the same account in Power BI.
Check Power BI Privacy Settings
Go to File > Options and Settings > Privacy Settings in Power BI Desktop.
Set the privacy level to Organizational or Public to allow data access.You can also try different import method, like try uploading the Excel file to Power BI Service and then connecting to it from Power BI Desktop.
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Regards,
Chaithra
Hi Ch ,
Thanks for your input.
I got it to work with your tips on PowerBI desktop, but I still had issues to get the data refresh (again credetial issues), so but decided to switch to a table (over an excel file) to have more control. (the excel was generated from a form, not I'm using a powerautomate to fill the table with the content).
Thanks for ther pointers anyway!
Gerrit