Forum Discussion
Web.Contents data source settings code
This documentation show how to package credentials into a record to be sent in your web calls.
Handling authentication for Power Query connectors | Microsoft Docs
Also, if users are getting prompted for credentials, you may want to consider settings up Dataflows to hold your data for your users to build reports againsts.
Regards,
Pat
I followed all of those suggestions in the connectors help document.
Sadly Power BI handles "credentials" and "authenication" in totally different ways. So you can set your Authentication, but are still required to set the credentialing method via the GUI.
If you do a web.contents("google.com", XYZ), no matter what you put for the XYZ you are still asked for credentials via the GUI.
And the dataflows still wouldnt work, because then *I* would have to click the GUI credentails 50-100 times a day when the new list of urls is published... 😜
It just seems like either there is something super easy I am missing, or it is impossible.
EDIT: by the way... when I was learning Power BI, you are the only person who, when I saw your name in the post, would be like "ok, time for the real dope answer!"
Thanks for how much you contribue to the community!