Connecting to multiple url's (simular to "folder" for a file server)

[Petter_Bakke]

I hope someone will be able to help me with to collect data from multiple web-adresses into one analyze. The url-adresses is simular except the last part, see example below.

• https://www.handball.no/system/kamper/kamprapport/?matchid=6802729
• https://www.handball.no/system/kamper/kamprapport/?matchid=6802719

I have a separate query giving me the last digits, eg. 6802729, 6802719 etc. By adding this to the frist string "https://www.handball.no/system/kamper/kamprapport/?matchid=" I get a set of urls containing the data I want. The content of each address is the same form.

There are too many urls for it to be practical to connect to every single datasource separatly.  Therefore, what I hope to achieve is to collect data from the different urls into one analyse, similar to what PowerBi offers for the source “folder”.

Is this possible?

-petter bakke

[v-shex-msft · Accepted solution]

HI @Petter_Bakke,

Nope. power bi not support this, you need to manually achieve this.

For you scenario, you can create a table with all item number which you wanted, then add a custom column with web connector function to get data from each row items and use expand feature expand all records.

Regards,

Xiaoxin Sheng

[Petter_Bakke]

Thank you for your reply!

As you suggest, I have created a table of all the item numbers I want, and used these to create a table of url's. I would, however, appreciate your advice in how to add "the custom column with web connector function to get data from each row items and use expand feature expand all records". 

Your advice is appreciated!

-petter bakke