This is my scenario.
I have a system that can only export 1000 records in HTML format at a time. I then put the file in a file share. I then create another HTLM file with the next set of 1000 records and put it into the same file share.
I then go into Power BI and get the source data from the file share. Have setup a not so good looking Dashboard “First One and learning lots from DNA Training”
Every Friday I do another extract of the next new 1000 records and add it to the file share. I am now up to 101 HTML files in the file share “11000” records.
The issue that I am having is every time I have to hit the refresh the data and it is taking a very long time to do the refresh.
Is there a why that Power BI can just append the new records?