Bypass Credentials Dialog via Code

[rodzillacorp]

I have an M function which takes a URL as a parameter and then retrieves the data for further processing.   I'm calling that function with a list of URLs (could be hundreds) and for each url I have to specify the credentials as anonymous.  Is there a way to do that in the code so I don't have to interact with the dialog in PBI Desktop for each one?

Current code is:

(siteUrl as text) as table =>
let
Source = Table.FromColumns({Lines.FromBinary(Web.Contents(siteUrl), null, null, 65001)}),

'do more stuff here

Any help anybody can provide is much appreciated.

[v-yulgu-msft]

Hi @rodzillacorp,

From below thread, it seems that currently we cannot specify credential in Power Query so that viewers don't have to provide credentials manually for data source connection. 

Storing Credentials in a Power Query

Best regards,
Yuliana Gu