cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaulDBrown
Super User
Super User

The dreaded data credentials error ...

I have a PBIX file where all data sources are online (Wikipedia, Github, Sharepoint, webpages...

Sources.JPG

 The credentials for Sharepoint are correct using an Organization account. All is fine if I refresh on Desktop. However I get the dreaded missing credentials error on the service (and I cannot work out which credentials are missing)...As I said, refresh works fine on Desktop.

5A6134CB-EA96-4DC2-97BF-CABCC7C6D81C.png

 

I would very much appreciate any help on this. Thanks!





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






1 ACCEPTED SOLUTION
Watsky
Super User
Super User

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.


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

View solution in original post

8 REPLIES 8
v-yalanwu-msft
Community Support
Community Support

Hi, @PaulDBrown ;

Glad to hear it worked,  If your problem is solved,  Would you mind accept the replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.


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.

Watsky
Super User
Super User

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.


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

View solution in original post

@Watsky  Genius!!
I'll have to work through the different (real) sources but I just tested your suggestion with 3 online sources as a test and it worked! Thanks so much for your help. I'll report back once I've updated the real queries.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@Watsky  Works like a charm in the report queries. Thank you again!





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Glad to hear it @PaulDBrown🤓


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

v-yalanwu-msft
Community Support
Community Support

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.

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 SOURCE1 SOURCE2 SOURCES2 SOURCES3 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?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






AGarrido
New Member

I've just the same problem. I can refresh on desktop and publish .pbix, however it's not possible to refresh on service, neither scheduled nor on demand.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!