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,...
Need Help
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

      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. 

      • aj1973's avatar
        aj1973
        Community Champion
        2 years ago

        How about the Amazon source? is it mapped?