Forum Discussion

nikhil0511's avatar
nikhil0511
Advocate I
3 years ago
Solved

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...
  • davehus's avatar
    3 years ago

    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.