Import CSV Files - Then Total Them

[Stephen001]

Hi,

I have One Drive Personal and 18 csv files from 18 different reports that I want to bring in and link to which I can do by creating 18 datasets in PowerBi. However how do I add them all together so I can get a total and then manipulate that data - can I do that in PowerBi please  - or do I need to do this manually by combining all the csv files myself, creating a new totals table and then importing that ?

Ideally, I want to have a totals dashboard that updates every hour from the individual reports coming in but am not sure how best to do this.

(Just a thought - I could link 18 Google Sheet files to 18 PowerBi datasets but again how do I combine these into one report for the totals please ?)

Many thanks for the help

Stephen

[Anonymous · Accepted solution]

@Stephen001,

I can't find any solutions to connect to OneDrive for personal folder in Power BI, but there are other two options for you.

1. Put all the CSV files in a local folder, then connect to the local folder using Folder connection in Power BI Desktop, you can combine all the data of the CSV files in a single table, and create report in Power BI Desktop. Then you can publish the report to Power BI Service, and set schedule refresh with gateway, this way, once you have any data changes in csv files, Power BI report will get updated based on refresh schedule.

2. Put all the CSV files in OneDrive for bussiness folder, then connect to the folder by entering the following URL in SharePoint Folder connector of Power BI Desktop. You can combine all the data of the CSV files in a single table, and create report in Power BI Desktop. Then you can upload the report to Power BI Service, and set schedule refresh without gateway.

https://mydomain-my.sharepoint.com/personal/user_mydomain_com

Regards,
Lydia