Forum Discussion

BarryFletcher's avatar
BarryFletcher
Icon for Helper III rankHelper III
1 year ago
Solved

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?

 

 

 

 

 

Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    1 year ago

    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.

  • Shahid12523's avatar
    Shahid12523
    1 year ago

    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

  • GeraldGEmerick's avatar
    GeraldGEmerick
    Icon for Memorable Member rankMemorable Member
    1 year ago

    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.

  • Shahid12523's avatar
    Shahid12523
    Icon for Community Champion rankCommunity Champion
    1 year ago

    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.

  • v-echaithra's avatar
    v-echaithra
    Icon for Community Support rankCommunity Support
    1 year ago

    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.

  • v-echaithra's avatar
    v-echaithra
    Icon for Community Support rankCommunity Support
    1 year ago

    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's avatar
      BarryFletcher
      Icon for Helper III rankHelper III
      1 year ago

      Hi,

       

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