Forum Discussion

rodzillacorp's avatar
rodzillacorp
New Member
8 years ago

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.