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 folder of csv's from a local computer that would be ideal.

 

Thanks

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

1 Reply

  • 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