Power BI Report Builder Query 'explodes' after adding measure

jacccodezwart — Tue, 28 Nov 2023 11:36:14 GMT

Hi all,

If have a report builder report that uses a query on a SSAS Tabular cube.

All works fine, until I add a new measure.

When I add this new measure all memory is used and the report crashes.

The measure works in power bi like in this table :

The measure (for example) #ArrivedLate is a count of all the rows having the the value 'Late' in a calculated column of the SSAS model. And the calculated column is a formule based on several time registrations.

All I want to do is recreate the table using the same measures, like this :

The column NumberOfTransports is a measure in the SSAS Tabular model as well, but this is a simple count formula. Same goes for the measure avgTimeOnTerminal, TotalLoadingTIme, TotalTimeOnTerminal which are all simple calculations.

So why does my query explode and use all memory when I add the measure #ArrivedEarly ?

Thanks in advance.

Jacco

topic Power BI Report Builder Query 'explodes' after adding measure in Report Server

Power BI Report Builder Query 'explodes' after adding measure