Combining multiple web based csv sources?

[Anonymous]

Hi all, 

I currently have a report with 15+ web based csvs as data sources. Is there a more manageable way to bring these into power BI?

If you could do this in the same way you bring in a folder of csv's from a local computer that would be ideal.

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous,

You can try to follow below steps if it suitable for your requirement:

1. Get data from csv file.

2. Click edit query to enter query editor.
3. Add custom column and replace the bold part to your column name which store url text.

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Web.Contents([Location]))

4. Expand the custom column.

Regards,

Xiaoxin Sheng