cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stephen001 New Member
New Member

Import CSV Files - Then Total Them

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Import CSV Files - Then Total Them

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Import CSV Files - Then Total Them

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 159 members 2,003 guests
Please welcome our newest community members: