Forum Discussion
Solved
Reducing Storage in Large Tables / Combining Composite model
My company only allows Power BI Pro license so we are such with the 1GB storage limit. I've been tasked with pulling in all our "issue" records, all the details as seamlessly as possible. My pla...
Try starting in Direct Query mode with one table for both Open and Not Open records, then create a manual aggregate table for your open items. This will allow any queries needing Open items to hit the import that will be created by the agg table and the closed items will use the DQ portion. Power BI Aggregation: Step 1 Create the Aggregated Table - RADACAD
Try starting in Direct Query mode with one table for both Open and Not Open records, then create a manual aggregate table for your open items. This will allow any queries needing Open items to hit the import that will be created by the agg table and the closed items will use the DQ portion. Power BI Aggregation: Step 1 Create the Aggregated Table - RADACAD