Forum Discussion
Problems with importing data from AWS Redshift
Hi Cengizhanarslan,
I have shrunk the report as much as possible, to fold the data to the source so that the data transformations are done in the sql query and the power query steps are reduced as much as possible.
However, before I did this the error message was the same, the report was a fraction too big, and needed to be made slightly smaller to work.
After massively reducing the report size, the same error message occured. This leads me to conclude it is not a Power BI memory issue. The same error message is given regardless of the report size.
Any ideas?
Hi Kevin8,
It's not the filesize of the pbix file that is the problem here, it's how much the data expands during refresh.
For an F64 capacity, the max memory available is 25GB, which is the limit you're hitting.
Can you describe more about what data sources you're using and what sort of transformations are being done?
Hi,
There are 29 queries. Its a star schema with one large fact table and many small dimension tables. The dmiension tables might have some power query steps such as columns removed or renamed. Or a key column added. Several of these have 5 - 10 rows. The largest has 9 columns and 750k rows , the next largest has 4 columns and 500k rows. The next has 5 columsn and 26k rows.
The main fact table has 88 columns and 11.5 m rows. It has a renamed columns step, and an append query where it adds an 88 row table.