Forum Discussion
Pivot table to power BI dataflows
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
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.
2 Replies
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.
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
