I'm running into an issue with cache size using a Data Flow connector in Power BI Desktop. The Expression Error reads: "The evaluation reached the allowed cahce entry size limit. Try increasing the allowed cache size." I went into options to increase the cache size; however, the current cahce size was almost 3.25 GB! Is this a compression issue with Data Flows? The entity is a simple transformations of orders (22 M-ish rows) without any aggregations. I can connect and import the data using a SQL Server connector but I was hoping to use a data flow to avoid having to transform the data each time I want to connect.
Also... shameless plug for incremental refresh for Pro users. When can we expect to see incremental refresh for those of us who do not have a large enough user base to justify the difference in cost between Pro and Premium?