Forum Discussion

mmx's avatar
mmx
New Member
8 years ago
Solved

Cumulating daily extract

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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