Forum Discussion
Save Measures or Calculated Column Values in a seperate table
Anonymous wrote:What would be required to create this from scratch?
it depends on which technologies you have at your disposal:
- one of the possible solution is in my previous post: Data Flow Gen. 2 -> Lakehouse -> Power BI Dataset -> Report (NB: requires Fabric/Premium capacity that is in preview)
- you could use SQL Server Integration Services
- you could use Azure Data Factory
- ...
I don't think you can do it with Power BI only.
You should read the data daily and store them somewhere (Azure SQL DB, Datalake, Sharepoint... whatever).
Append to the records the date of the snapshot so you can idenity snapshot date.
Having a daily copy of the data, building a dataset that has everything in it is as simple as that.
Having a Premium/Fabric Capacity you could build a Dataflow Gen 2 (if you like PQ) that reads the file and happends it in a lakehouse table daily. When the table is there you can build the report using the default dataset exposed by lakehouse.
I have the dataflow created. I also have the destimnation LakeHouse destination created. I can view the query results in the dataflow. How do I create the method to append these results to the Lakehouse ? In other words how do I move the data and how does it know to append ?
when developing dataflow you have chosen to append or to replace data in the destination table in the lakehouse. according to what you have chosen refreshing dataflow will append or truncate/insert data into lakehouse. with data in lake you can read them with power bi.