Error connection to Excel file on OneDrive

[gdenayer]

Hi,

I'm trying to buid a PowerBI dashboard, on a simple excel file on my Sharepoint(OneDrive).

I'm able to get through to the first steps, where powerquery asks to connect to the datasource. 

and I see this :

But after selection 'Create' i get the following error :

I tried with othe xls files, but this gives the same result.

Anyone has an idea ?

thx

G.

[v-echaithra]

Hi @gdenayer ,

Thank you for sharing your update and confirming that you dont have any issue. i request you to please accept your own post as the solution, this will help other community members who might face a similar issue.

Also would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Chaithra.

[rohit1991]

Hi @gdenayer

This error usually comes up when the file is on OneDrive/SharePoint but the connection isn’t set up the right way.

• In Power BI, use Get Data >> SharePoint Folder (not just Excel).

• Enter the site URL only, not the full file link.

• Sign in with your Organizational account.

• From the list of files, filter down to your Excel and then open it.

• If it still fails, go to File >> Options >> Data source settings, clear any old SharePoint/OneDrive credentials, and sign in again.

In most cases, switching to the SharePoint connector + clearing cached logins fixes it.

[gdenayer]

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

[v-echaithra · Accepted solution]

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