Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Versioned fact table report

I have a versioned fact table which has an effective start date and end date for each row. So the fact table supports the snapshot data at a point in time. Say we want to get a Total Of Sales each mo...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Anonymous

     

    1.  Possibly our prefered option is direct connect, so any tricks in the loading is not relevant in that case.

     

    You can still do this with DirectQuery depending on what your data source is. If it is sql server then you can take advantage of query editor even with directquery.

     

    But yes agree if rules are going to be complex and easy to implement via source do it that way (saying that you can still do it via power bi but depends on how complex rules are).

     

  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Anonymous

     

    In Power BI Desktop, it only takes the data from data source and render it. It doesn't support versioning. For your scenario, I don't think there's other way than using snapshot tables.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

Anonymous

 

In Power BI Desktop, it only takes the data from data source and render it. It doesn't support versioning. For your scenario, I don't think there's other way than using snapshot tables.

 

Regards,