Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • artemus's avatar
    artemus
    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you very much for your support artemus !

 

Kindly, could you provide me with an example or hint on how to make the custom connector bypass Power BI credentials? There are tutorials on how to build a custom connector (which I did), but I am still trying to figure out how to make it bypass credentials. 


Should this be enough for this purpose? 

 

 

Thanks! 

  • artemus's avatar
    artemus
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    You would need to do something like:

     

    Extension.InvokeWithCredentials((datasource) => [ AuthenticationKind = "Anonymous" ], () => Web.Contents("https://10.204.18.300/status.xml"))

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you very much artemus ! I haven't fully figured it out yet, but I'll get there thanks to your help.