Reducing Storage in Large Tables / Combining Composite model

Question

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 plan was to create two tables:

1. Containing all the Open records in Import mode for speed

2. Containing NOT Open records in Direct Query

3. Create a third table combining the two tables and I was hoping it wouldn't table up any space as it's only a reference using

issues = UNION(issues_import,issues_direct)

However the query the result is "The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows."

Using Power Query append doesn't seem to work because it creates the full imported tables.

I looked at data flows but couldn't see an option to pull in semantec models, any ideas? I wanted to create a table where the users can filter the data in one place rather than keep the tables seperate if possible.

Thanks in advance.

audreygerred · Accepted Answer

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.&nbsp;Power BI Aggregation: Step 1 Create the Aggregated Table - RADACAD
User-defined aggregations - Power BI | Microsoft Learn

Forum Discussion

Reducing Storage in Large Tables / Combining Composite model

1 Reply

Related content

Tables combine

Reduce PBIX file size

Data Combining Problem

Combine Column

Dynamic RLS combination