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.
Go to Solution.
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.
View solution in original post
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.