Add tables from an existing source

[BarryFletcher]

Hi all,

I have a Power BI file created and the source is an Excel file in a Sharepoint folder. When I connected the source there were 14 tables and all imported correctly but I have now added more tables to the source.

I am trying to connect to the source again to add the "new" tables from the spreadsheet bu I am now getting this error. Is this a Sharepoint error or a Power BI desktop error?

[GeraldGEmerick · Accepted solution]

@BarryFletcher It is technically a permissions error and web browser error. It is saying that you first need to add the site to your Trusted Sites in Edge most likely.

[v-echaithra]

Hi @BarryFletcher ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[BarryFletcher]

Hi,

The solution as susggestd on here was SharePoint permissions issue, I accepted as a solution earlier this week - thanks for the help

[v-echaithra]

Hi @BarryFletcher ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[BarryFletcher]

Thank you

[Shahid12523 · Accepted solution]

This is a SharePoint authentication issue, not a Power BI error.

Fix:

In Power BI → File > Options and Settings > Data Source Settings.

Select your SharePoint source → Clear Permissions.

Reconnect → choose Organizational Account to log in.

[GeraldGEmerick · Accepted solution]

@BarryFletcher It is technically a permissions error and web browser error. It is saying that you first need to add the site to your Trusted Sites in Edge most likely.