Forum Discussion
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
- danextian
Super User
Hi firdows_2407
A lot of reasons why you're expecting a performance issue and usually is due to the sheer size of the table and/or inefficent dax formula (such as filtering a table instead of just a column and/or applying filters on high cardinality columns). There's just not enough information provided. Please refer to this post on how to get answers quickly.
It is a lengthy one but helps you and everyone else save time.