Matrix exceeds available resources

[ggmm17]

Hello All, 

I am building a report (matrix) which is composed of about 50 calculated rows and about 20 calculated columns. the difference between columns is a first set of Actuals (dynamic actual scenario based on selection) for period 1 to 12, a second set for forecast (dynamic forecast scenario based on selection) and other set for budget (budget dynamic scenario based on selection) and other set for YOY (dynamic based on selection). 

There is a complex consideration to take into account, this report has some rows calculations that come from the data source (direct query) and the rest of rows are the 50 calculated measures I have created. In order to be able to display all in one matrix I have created a measure with SWITCH function to calculate the measure depending on the selection of each report with a bridge table where the user selects a common code that define the report rows and bring together the calcs from the source and the calculated measures to display in the rows. 

This woks fine for majority of reports where the number of calculated measures in rows is less than 10 but for this repor with about 50 rows calculated it seem to exceeds the available resources. The calculated measures are complex as they refer to othe rmeasures in order to reach to the right value. This is a standar set up that came with the standard data model and can not be modified.

I got Premiun per user capacity but still the matrix doest load. Any suggestions? 

I went through the below discussion but doesnt seem clear?: https://community.fabric.microsoft.com/t5/Developer/quot-Visual-has-exceed-the-available-resources-q...

Many thanks 

[ggmm17]

Thank you @Anonymous, 

The data source is other reporting tool wich does calculations on the fly. My connection is mixed, direct query to the reporting tool and direct data entry into PBI. Taking this into account, how would I add these calculations in the database? my understanding was that the premium license would increase the available memory to run these calculations? 

Many thanks

[Anonymous]

Hi @ggmm17 ,

In fact, the live connection means PBI directly link to the remote AS tabular engine as data model. You can’t directly add these on these calculation to the data source side when you work on mixed model. (even if you attach them on the data source table, these calculations fields will be fixed as static values)

Regards,

Xiaoxin Sheng

[Anonymous]

HI @ggmm17,

Currently I also not found any effective solution or workaround to handle with this scenario which caused by too many calculations.

What type of data source are you worked? If it supports 'live connection' mode, I'd like to suggest you consider create a standalone report and put these heavy calculations expression on the database side to use 'live connection' mode to link to the remote database.

For this scenario, these calculations are handled on the database side, and they should help you to reduce the resource spend and prevent the exceed to limitation issue.

Regards,

Xiaoxin Sheng