Streaming Dataset with Excel - Using flow to keep dataset updated

[shanecosgrove1]

Hi,

I am running into a problem with my streaming dataset. The data for the streaming dataset is rendered from an excel file stored in onedrive for business. I use flow to list all rows in the excel table every 1 minute and then update the Power Bi Streaming Dataset.

This works fine the first time the flow runs. However when the flow runs again the data get duplicated .

For example

Row one has a value of 20 the first time.

The second time the flow runs this value will become 40 then 60 then 80 and do on.

Is there any way to get flow only to add newly entered columns to the streaming dataset.??

[v-danhe-msft]

Hi @shanecosgrove1 ,

Based on my test, it do will duplicate the data in Power BI and it seemed that show no other filter for power Bi in flow to solve this problem, I suggest you create this topic in Power Flow forum to ask for detail information:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity

Regards,

Daniel He