Forum Discussion
Bypass Credentials Dialog via Code
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.
1 Reply
- v-yulgu-msftMicrosoft Employee
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