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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your quick answer. That's what I understand as well.

 

Currently I was suggested to create two dataflows in PBI Services and both connect to and import the Tabular Model from Analysis Service. One is to automatically refresh the data once the Tabular model is processed and the other one will be refreshed manually, and then create another PBI report using these two Dataflows as source and create a report.

 

I'm not even sure if this is doable and do you have any idea on this approach? Thanks

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
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.