Pivot table to power BI dataflows

[nikhil0511]

Hello All,

I have a table data stored in Pivot table, this data keeps updating on daily refresh of my Excel file. I want to save this data in a dataflow in a incremental way so that I can check same items are changing over and over with a date added.

I tried creating two tables in my workflow, one to fetch data from the Pivot table, then other table keeps appending new data on every refresh of workflow. but its not working.

Any idea how to solve or acheive my task

Thank you

Nikhil

[nikhil0511]

@davehus

thank you.

Can this be possible if I push my data into ADSL and try to append new data to exisiting data there?

Regards

Nikhil

[davehus · Accepted solution]

Hi @nikhil0511 , 

A dataflow is basically a refreshable table, so it doesn't store data. You would need a database table or maybe a dataverse table to achieve this. Alternatively a vba to append the data to an excel document would also work.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.