Forum Discussion
Append daily Excel data into existing Query
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,
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
Thanks for this reply. I too am concerned about the performance of the buildup of append files over time for this same scenario. Related to the option of exporting the data and adding it to the master file - I want to do this, but I'm having issues extracting all of the transformed data from edit queries, as it will only allow me to export 1000 rows from my transformed data query to Excel.
As well, I have also tried adding a table visual, adding all the columns I want, and exporting the transformed data from the front end. This also has a significant limitation and is not allowing me to export all rows.
Any suggestions? I need to grow my dataset using append similar to the original poster, but am running into roadblocks with extracting all of the transformed data.
Hi,
I have similar concern, AnyOne from Microsoft Community suggest a solution Please?
Thanks in Advance,
Regards
