Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Save Measures or Calculated Column Values in a seperate table

I have one flat file. A full refresh occurs daily.  Within the table are the day's current status. Number Pending, New Orders, etc... In turn, I have visuals that show the counts for the current day...
Need Help
  • R1k91's avatar
    R1k91
    2 years ago
    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 

    - ...

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ?

R1k91's avatar
R1k91
Super User
2 years ago

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.