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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

The credentials provided for the SharePoint source are invalid

Hi All,

 

I have recently added another SharePoint site data source to my Power BI model.

For some reason, I keep getting the attached error. As you can see, I have two different SharePoint sites, and the configuration / credentials are the same, so not sure why I’m getting this error.

I did some research on the community for this error (“The credentials provided for the SharePoint source are invalid”) and saw some topics with potential solutions, but none of them solved the error.

 

For example:

https://community.fabric.microsoft.com/t5/Service/The-credentials-provided-for-the-SharePoint-source...

https://community.fabric.microsoft.com/t5/Service/The-credentials-provided-for-the-SharePoint-source...

 

so I have tried the following:

  • Unlink the mapping between the site to the model (since Gateway is not required)
  • Verify that site url starts with ‘https’ and not ‘http’
  • Verify the credentials again. Sign in again.

 

In one of the topics, a Microsoft employee advised that this issue has been fixed. But not in this case.

 

Any kind of assistance here is more than welcome.

 

Thanks!

 

@aj1973 @lbendlin @v-jiascu-msft @nadavsn @fenixen 

 

powerapps1.JPG

14 REPLIES 14
Anonymous
Not applicable

So, how can i merge Sharepoint list to another data source (SQL) ? as it seems it fails on this step..

aj1973
Community Champion
Community Champion

Not sure why it still fails but you can create a Dataflow where you get her all your sources and then create your pbix

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

I've tried but from Dataflow i can't even connect to the Sharepoint list. 

powerapps6.JPG I also tried to copy the m code from the pbix file to the dataflox but get same error: (configure connection button takes me to the sharepoint credentials menu but all i did wasn't solved it)

 

powerapps7.png

aj1973
Community Champion
Community Champion

This is what explains all your issue. If Power Query Online can't connect to your Sharepoint List then that's why your merged tables in the pbix did want to connect.

You need to verify your credentials and why can't you connect with your Sharepoint Admin

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

So how you explain the fact that I can connect from the pbix file and without the merge everything works fine ? including the service refresh of course..

As I have one username/ password- I don't know what else I can do. 

aj1973
Community Champion
Community Champion

I don't know how you connect in your desktop ! is the sharepoint list in question On Prem? is it really a List? can I see the M code please?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

Hi @aj1973 

See below: 

powerapps8.JPG

aj1973
Community Champion
Community Champion

Hi @Anonymous 

It doesn't seem like you are connecting the right way

aj1973_0-1706710378115.png

PowerBI and PowerApps are folder's names aren't they ?

 

The link should look something like this

aj1973_1-1706710486419.png

after Sites/ comes the name of the groupe in Sharepoint. Then in Power Query you can look for your folder and files.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

Hi @aj1973 

This is how i connected.. my URL and yours are exactly the same.

Actually, I just realized that it matter of privacy level. in the failed query that I listed above, I have a merge step where I join the data from this SharePoint site to a query comes from my SQL source. once I removed it, refresh complete. i just need to understand now how can I configure it correctly, so it will work with this merge step as it mandatory to this query. 

aj1973
Community Champion
Community Champion

That's what is, the merge! 

Please take a look at this

Merge or append on-premises and cloud data sources - Power BI | Microsoft Learn

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

@aj1973 

Actually i have seen this article, and created a new connection. then I replace the mapping on the dataset settings from 'Personal Cloud Connection' to the new connection I've created (powerapps). but still same error. powerapps4.JPG

aj1973
Community Champion
Community Champion

How about the Amazon source? is it mapped?

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

Yes, it mapped on the Gateway section. powerapps5.JPG

Anonymous
Not applicable

Update: I have created a new report.

first added one of my SharePoint sites - publish it > refresh complete

then added the 2nd SharePoint site  - publish it > refresh complete

then added my SQL source (gateway required)   - publish it > refresh complete

 

So I don't understand why it fails on one report but succeed on another.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors