Forum Discussion
Add tables from an existing source
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?
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.
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.
6 Replies
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.
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.
Thank you
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.
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.Hi,
The solution as susggestd on here was SharePoint permissions issue, I accepted as a solution earlier this week - thanks for the help
