thank you so much for sharing this Toby!!!
Toby this is awesome!
Thanks for being always willing to share your insights with the Community!
thank you for sharing, we were experienced a half day to search over this issue, and we found that we were not embedded password in our data source, once it published.
I would say thanks to our infra team for helping us to solve the problem. Herewith i attach the picture to make it easy to understand.
Edit Data Sources, set the authentication as embedded password.
Hope it will be useful. Thank you.