Forum Discussion

firdows_2407's avatar
firdows_2407
Frequent Visitor
1 year ago

Memory issue while creating ageing report in Power BI

Hi All,

 

I'm creating a region wise ageing report in the below sequence. But, i am facing memory issue when i try to display for more than one bucket.(For your info. My total records for all the regions were nearly "2 crores")

 

I want to display in this sequence (0-21 days, 22-30 days, 31-60 days, 61-90 days, 91-120 days) in the table visual.

l am trying to replicate in dashboard by using the selection date slicer (where if I select a particular date in the slicer, then it calculates from selected date to back days based on the sequence). 

Ex:

If i add one bucket i.e., 0-21 days then the data is displaying. But If I add another bucket then I'm facing memory issue.

If I add another column, i am getting the below popup.

If I filter for one region, then I can see the data for three buckets and if I try to add another bucket again I am facing the same issue. Here AP region total records were nearly "30 Lakhs"

We are not facing any issue, if total records are less than 10,000, when we filter for a sinlge region.

Please suggest any solution to this.
Thanks in advance!!

 

1 Reply