Solved: Cumulating daily extract

mmx · ‎02-08-2018

hello,

i'm new on this forum and it seems very useful !

i've a question :

Everyday, i receive an extract of the confirmed production workorders of the day before. I'd like to cumulate in a single table all these daily extractions in order to be able to compare historical production.

i think it must be easy to implement, but i'm newbee with powerbi...

could you help me?

Thanks a lot

Marc

Anonymous · ‎02-08-2018

@mmx,

Do you store the data in Excel/CSV file? If so, you can put these files in a folder, and use Folder connector in Power BI Desktop to connect to your data source, this way, all data will be cumulated in a single table.

However, if you store data in different data source, you can import data from these data sources in Power BI Desktop, then use Append Queries to combine data in a single table.

Regards,
Lydia

View solution in original post

Anonymous · ‎02-08-2018

@mmx,

Do you store the data in Excel/CSV file? If so, you can put these files in a folder, and use Folder connector in Power BI Desktop to connect to your data source, this way, all data will be cumulated in a single table.

However, if you store data in different data source, you can import data from these data sources in Power BI Desktop, then use Append Queries to combine data in a single table.

Regards,
Lydia