Forum Discussion

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago
Solved

The dreaded data credentials error ...

I have a PBIX file where all data sources are online (Wikipedia, Github, Sharepoint, webpages...  The credentials for Sharepoint are correct using an Organization account. All is fine if I r...
Need Help
  • Watsky's avatar
    Watsky
    4 years ago

    Hey PaulDBrown , 

    What source connection string are you using for them? Are any of them Web.BrowserContents? If so change them to Web.Contents and see if that helps.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, PaulDBrown ;

 The error typically happens when the credentials of the dataset been changed. 

1.You can do a test on the desktop, connect to the data source and manually refresh it, if it failed, please clear the datasource setting and relogin. 

 

2.If it still doesn't work,You probably already have a data gateway but the account it is set to use can't access the file. try to add a gateway .then change the credentials.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Thanks for the suggestions. I've been playing around with a blank file and adding online sources one by one. It appears that the Credentials cannot be edited (set) if more than 2 online sources are used.

1 SOURCE2 SOURCES3 SOURCES

I've tried changing the order in which the sources are added and there is no apparent improvement (so the type of source doesn's seem to be the issue)

Is there a documented max number of (online) sources allowed?