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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
gbarr12345
Post Prodigy
Post Prodigy

SharePoint and Power BI error message

Hi everyone,

 

I'm trying to publish a Power BI report to SharePoint and I'm following the following steps below but getting the following error message - 'We couldn't authenticate with the credentials provided. Please try again'.

 

I used the URL taken from SharePoint but don't know the steps to fix this.

 

Can anyone help? 

 

I've the screenshots below:

 

gbarr12345_0-1721863340712.png

 

gbarr12345_1-1721863397538.png

 

gbarr12345_2-1721863438779.png

 

 

 

 

1 ACCEPTED SOLUTION
RossEdwards
Solution Sage
Solution Sage

While inside the "Transform Data" section of Power BI, there is an area that holds the saved credentials to all of your sources.  Back out of the "Get Data" screen and locate a button called "Data Source Settings".

 

RossEdwards_0-1721868036228.png

 

 

If you have already got the sharepoint connection inside one of your queries, it should appear in the "Data sources in current file".  If not, select the "global permissions".  Locate the entry for your sharepoint source, click on it and you should see a button at the bottom called "Edit Permissions".  Update the permissions with a username/password that is authorised for that SharePoint site.

 

If the sharepoint site is hosted on an internal server, you'll like use "Windows" type credentials.  If the SharePoint site is host using SharePoint Online, you'll need to use "Microsoft Account"

View solution in original post

2 REPLIES 2
RossEdwards
Solution Sage
Solution Sage

While inside the "Transform Data" section of Power BI, there is an area that holds the saved credentials to all of your sources.  Back out of the "Get Data" screen and locate a button called "Data Source Settings".

 

RossEdwards_0-1721868036228.png

 

 

If you have already got the sharepoint connection inside one of your queries, it should appear in the "Data sources in current file".  If not, select the "global permissions".  Locate the entry for your sharepoint source, click on it and you should see a button at the bottom called "Edit Permissions".  Update the permissions with a username/password that is authorised for that SharePoint site.

 

If the sharepoint site is hosted on an internal server, you'll like use "Windows" type credentials.  If the SharePoint site is host using SharePoint Online, you'll need to use "Microsoft Account"

That's great, thank you for your help Ross!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.