Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sharepoint Query Connection Isssue

Hi Guys,   I am trying to develop a report in which I get data from an excel file in a sharepoint folder.   My manager shared this folder with me so I copied the path of an excel report in this s...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint,  click "Edit permissions", then click "Edit", choose organizational account method (or Microsoft account) to sign in the appropriate credential.

     

    or click "clear permissions" for stored SharePoint data source, then connect to the data using SharePoint folder connector again, use the URL below and use organizational account method.  See more: Connecting to Files in SharePoint & OneDrive with Power BI / Power Query.

     

    https://xxxxx.sharepoint.com/sites/<sitename>

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

You may go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint,  click "Edit permissions", then click "Edit", choose organizational account method (or Microsoft account) to sign in the appropriate credential.

 

or click "clear permissions" for stored SharePoint data source, then connect to the data using SharePoint folder connector again, use the URL below and use organizational account method.  See more: Connecting to Files in SharePoint & OneDrive with Power BI / Power Query.

 

https://xxxxx.sharepoint.com/sites/<sitename>

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.