Forum Discussion

shanecosgrove1's avatar
shanecosgrove1
Frequent Visitor
7 years ago

Streaming Dataset with Excel - Using flow to keep dataset updated

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.??