I am getting the following memory limit error in PowerBI report

[dsrajapaksa]

When I opne the PowerBI report I am getting the following Memory limit issue. May I know what could be the possible reason for this? I also having issues loading data to the visualizations as it takes very long to load data to visuals. I'm new to Fabric and may I know how I can rectify this issue. 

[v-dineshya]

Hi @dsrajapaksa ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @cengizhanarslan , Thank you for your prompt response.

Hi  @dsrajapaksa , could you please try the proposed solution shared by  @cengizhanarslan  ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

Regards,

Dinesh

[v-dineshya]

Hi @dsrajapaksa ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[cengizhanarslan · Accepted solution]

1) Introduce proper dimension tables

You need a true star schema:

• One or more dimension tables (Date, Customer, Product, etc.)

• Each fact table connects only to dimensions

• No fact-to-fact relationships

Example:

DimCustomer ──▶ Fact_A DimCustomer ──▶ Fact_B DimCustomer ──▶ Fact_C

Then in the visual:

• Columns → from dimension tables

• Values → measures from facts

 Do NOT put fact columns directly into the table.

2) Use measures, not fact columns

Instead of this (problematic):

• Fact_A[Amount]

• Fact_B[Cost]

• Fact_C[Quantity]

Do this:

Amount A = SUM ( Fact_A[Amount] )
Cost B   = SUM ( Fact_B[Cost] )
Qty C    = SUM ( Fact_C[Quantity] )

And put:

• Rows → dimension attributes

• Values → these measures

This avoids row-level joins completely.

3) Check and fix relationship directions

Make sure:

• Single-direction filters from Dimension → Fact

• Avoid Both unless strictly required

• Avoid many-to-many unless unavoidable

Many-to-many + table visual = memory disaster.