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

Prabunathan's avatar
Prabunathan
Frequent Visitor
8 years ago

Hi Lydia,

 

Thank you for your suggestion and yes that works fine. 

 

Kindly advise if the data refresh would consume more time due to the fact that there will be a build up several data files in the folder ( say after a period of 60 days there would be 60 Plus files to collate the data from each time I refresh the data ) . 

 

Is there a possibility that, i append the latest file to the data query and discard the file each day. Can this be automated placing the data file in a one drive folder.

 

Thanks again inadvance.

 

Prabu

 

 

Anonymous's avatar
Anonymous
Not applicable
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