topic Re: I am getting the following memory limit error in PowerBI report in Report Server

I am getting the following memory limit error in PowerBI report

dsrajapaksa — Mon, 30 Mar 2026 09:08:50 GMT

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.

Re: I am getting the following memory limit error in PowerBI report

cengizhanarslan — Mon, 30 Mar 2026 14:39:54 GMT

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.

Re: I am getting the following memory limit error in PowerBI report

v-dineshya — Thu, 02 Apr 2026 14:49:08 GMT

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

Re: I am getting the following memory limit error in PowerBI report

v-dineshya — Mon, 06 Apr 2026 05:02:42 GMT

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