Intraday Incremental Refresh Issue

[SWhiteMKL]

All,

I have a requirement that is as follows:

1. Need to capture network and device information from our existing edge devices. This informaiotn is written to a table regulraly throughout the day for each device.  

2. Each device only maintains 1 record in the table and it is updated periodically throughout the day (say every 30 minutes)

3. PowerBI can inrementally load data but is looking for a day at a time so the issue is I am only getting the final record for the day and not the history of records througout the day.  

example:

Row initially created at 8 AM

Row updated (not new row created) at 10 AM

Row updated at 12 PM

Row Updated at 4 PM

I need to capture all 4 rows but current incremental refresh is only giving the last row of data

Can this even be done?

Thanks,

Steve

[Anonymous]

Hi @SWhiteMKL,

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[Anonymous]

Hi @SWhiteMKL,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.

Warm regards,

Prasanna Kumar

[Anonymous]

Hi @SWhiteMKL 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Deku · Accepted solution]

This is not possible. You need a ETL/ELT job to write this data to a database/lake/warehouse