Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How many aggregation tables are required?

Hi there,

I have created a composite model in Power BI (1 fact and 15 dimensions). This will be used as a signle dataset for 20 or 30 reports for my client.

Question is, what could be the best strategy to plan and create aggregation tables like how many aggregation tables need to create or one or two generic aggregation tables can be created to use across all report? Or there will be 1 aggregation tables per report?

Any help will be highly appreciated.

Thank you

 

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you for your reply amitchandak 

      I have more than 100 million records in fact table and in few dimentions too.

      I need to understand if I need to create one big aggregated table which will service (may be) 90% of the queries generated by different reports. Or I need more than one aggregation tables to service reports?

      Probably one aggregation table per report does not make sense.

      Is there an article, how to plan or design aggregation tables in a composit model?

      I don't want to add an aggregation table every few days in my centralized Power BI Model.

      Thank you

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak 

      No, this link does not provide what I'm looking for.

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        Since we don't have your data, and we don't know what will be used in your report, so it is difficult for us to provide you detailed suggestion. All we can provide is general suggestion like https://www.youtube.com/watch?v=EhGF372t0sU

         

        Best Regards,

        Dedmon Dai