Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Combining multiple web based csv sources?

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 fo...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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