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

OK, so I've decided to create one master file in the cloud environment and use the SQL souce to copy and append to this master on a scheduled basis.  What would be required to create this from scratch?  Once created, I want to link my Power PI front end report to the newly created master file. It will be the only table I work with.

R1k91's avatar
R1k91
Super User
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 

- ...