Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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-are-invalid/m-p/2895781

https://community.fabric.microsoft.com/t5/Service/The-credentials-provided-for-the-SharePoint-source-are-invalid/m-p/562521/page/2

 

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 

 

Need Help

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    Hi Anonymous 

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

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

     

    The link should look something like this

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

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

         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)