Forum Discussion
Anonymous
3 years agoNot applicable
Extract data from multiple URLs without having a valid static URL.
Hello everyone! I am trying to extract data from a list of more than one hundred urls. The goal is to be able to append all the data from all urls in a single table. The problem is that the struc...
- 3 years ago
The issue is that we capture the credentials used for each website seperatly, and while you can use different credentials for different levels of the url, there isn't any for the base url.
Your only option is to create a custom connector, which can bypass the credential check. Note that if you do this you must use Power Bi Desktop (not Excel), or if you deploy online, you will need to use a gateway.
artemus
3 years agoMicrosoft Employee
You would need to do something like:
Extension.InvokeWithCredentials((datasource) => [ AuthenticationKind = "Anonymous" ], () => Web.Contents("https://10.204.18.300/status.xml"))
Anonymous
3 years agoNot applicable
Thank you very much artemus ! I haven't fully figured it out yet, but I'll get there thanks to your help.