Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Change Data Source to Sharepoint

Picture 1Picture 1Picture 2Picture 2Picture 3Picture 3Picture 4Picture 4Hello,
please, I need to change source in my Power BI report and connect it to sharepoint.
I have the access to the sharepoint.
 
But there is error message that it’s not possible to authenticate with my credentials…

1. picture -> I need to sign in

2. picture -> I’m already signed in

3. picture -> I need to choose the level to which are the settings supposed to be applied

4. picture -> And then the error message


Thank you in advance!

Best regards,
Michal Slavik

Status: Needs Info
Comments
v-yuezhe-msft
Employee

@Anonymous,

What version of Power BI Desktop do you use?Do you want to connect to SharePoint online folder or SharePoint online file?

Please follow the steps below and check if it works.

1. Import Sharepoint data source in a new PBIX file, please make sure that you have cleared the existing sharepoint permissions in Power BI Desktop before you import data.

2. Go to Advanced Editor and copy data source code.

3. go to your original table that points to the old data source and replace the source code with the new source code.



Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Needs Info
 
v-yuezhe-msft
Employee
Status changed to: Needs Info
 
Anonymous
Not applicable

Hello,
this is something I've already tried. The problem is that I can't connect the sharepoint with Power BI, so I also can't upload sharepoint data.

I want to upload excel files from sharepoint folder to Power BI. I use the latest version of Power BI.when I put url to folder where the excel file is.PNG

Thank you in advance,
Michal Slavik

v-yuezhe-msft
Employee

@Anonymous ,

What is the result when you use SharePoint folder connector in  Power BI Desktop? Do you enter the root URL of SharePoint site?

Regards,
Lydia