undefined

Good morning!

I really appreciate all the help provided, however, I have not managed to mount the process through Incremental Updates. I think something is wrong with me in creating the process that way, but I don't know what it can be.

Finally, I had to set up the process in parts, which I tell you in case they were helpful on occasion or if you see that there is a better way. The process has been concluded as follows:

1. Data flow that updates the table obtained via OData connection.

2. Connecting Excel to the previous Flow to update that day's data.

3. Power Automate scheduled flow to convert Excel to HTML as a daily file to generate a repository.

4. Connection of Excel to folder of HTML files to have the accumulated historical.

5. Connect Power BI to Excel_Histórico to get all the information.

I know that it is an inefficient process, which also requires that the connection to the Gateway be active (computer on), but it is the only thing I have been able to mount with the available means.

I wish I could improve it, but the reality is that I don't quite know how to do it, so any help will be welcome.

Many thanks to all for your interest and help!!