Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
CarlSagan
Helper II
Helper II

Running totals causing visuals to exceed limit of memory and crash.

I have a report that has multiple pages using running totals (same ones multiple times). In this report, the visuals were loading and working at one point in time and now they exceed the limit and none of them are loading. I created another power bi project to see if the visual would work if I only had one page and it did. 

  • Does a report with multiple pages cause the project to get bloated with computation and cause slowdowns? As in, when I'm looking at one page, do the other inactive pages have an effect on the active page?
  • Are there ways to reuse running total columns to speed up the visual so it doesn't crash? How can I tell if it's the size of the data set or my algorithm that is the main culprit?
  • Why do the same visuals crash in one project but work in another?
3 REPLIES 3
v-cgao-msft
Community Support
Community Support

Hi @CarlSagan ,

A report with multiple pages can cause the project to get bloated with computation and cause slowdowns. When you are looking at one page, the other inactive pages do not have an effect on the active page. There are ways to reuse running total columns to speed up the visual so it doesn't crash. You can use the Performance Analyzer tool included in Power BI Desktop to identify visuals that are impacting the performance of a report, and identify the reason for the impact.

 

To determine if it's the size of the data set or your algorithm that is the main culprit, you can use the Performance Analyser tool to collect the related json file which will contain the load time for each one of the visuals and identify the bottleneck. You can also use DAX Studio to test DAX queries that the customer is using and study their performance.

Importing Performance Analyzer data into DAX Studio - SQLBI

 

The third question is to be analyzed based on differences in data sets or environments. Regarding the measures, You can use the Performance Analyzer tool to identify which visual is causing the issue, and identifies which aspects of the visual is taking the longest duration to process.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

ToddChitt
Super User
Super User

How are you implementing the Running Totals? In DAX or Power Query? Can you show us your code, and maybe a snippet of your data?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Here are some examples of the code in dax

Last Contributions = 

VAR mostRecentMonth = LASTDATE(Assets[process_period_date])
VAR prevMonth = PREVIOUSMONTH(mostRecentMonth)
var result = CALCULATE(
                SUM(Assets[amount]),
                Assets[tran_code] = 101 ||
                Assets[tran_code] = 102 ||
                Assets[tran_code] = 103 ||
                Assets[tran_code] = 109 ||
                Assets[tran_code] = 133,
                Assets[process_period_date] = mostRecentMonth
)
RETURN result

 

Beginning Balance = 
VAR lastD = LASTDATE(Assets[process_period_date])
var lastM = MONTH(lastD)
VAR prevM = PREVIOUSMONTH(lastD)

var begBal = CALCULATE(
                SUM(Assets[amount]),
                Assets[process_period_date] <= prevM
)

RETURN begBal

 

Then a measure that is using all the running total measures in one expression

Last Ending Balance = 
    [Beginning Balance] + [Last Earnings] + [Last Expenses] + [Last Distribution] + [Last Contributions] + [Last Transfer Total]

 

Here is an example output I am trying to get (filtering to one row to show you what it looks like)

CarlSagan_0-1692202553718.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.