Forum Discussion

Prabunathan's avatar
Prabunathan
Frequent Visitor
8 years ago
Solved

Append daily Excel data into existing Query

Hi,   I have a dashboard created on PBI Pro using dataquery derived from an excel master file.    Now i am looking for an automated process, where in my daily sales data file  (excel) could be ap...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Prabunathan,

    If you discard the files in the folder, I am afraid that you will get errors in the report when you refresh the dataset in power BI Service.

    If you concern about the amount of the files, consider to add new data in your original Excel file.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Prabunathan,

In your scenario, you can put all the files in a single folder, then use the Folder connector in Power BI Desktop to connect to the folder and load data. 

After you create report in Power BI Desktop and publish the report in Power BI Service, set schedule refresh for your dataset. This way, when you add new files to the folder, all the new data will be appened into the existing query.

Regards,
Lydia