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.

artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
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.