Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Store Measures Somewhere for Historical Analysis

Hi, I'm now facing a scenario like this: 0. My Tabular model is running in Analylsis Service and My PowerBI is connecting live to the model right now. 1. I have a SCD type 1 Product table 2. I hav...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    You can definitely use the DataFlow approach. Stagger the refreshes, or refresh manually as you are doing.

     

    You can also use this incremental refresh hack just published today, but it requires a SQL Server to link the data to (or any foldable data source) and not sure how it would work with SSAS. The example is using a CSV file.