Performance issue because datasource being called multiple times

[tinytimtwo]

I have a dashboard with seven indicators. The value of each indicator is from the same datasource which executes a stored procedure.
In Preview mode the stored procedure is only being called once but in production the procedure is being called seven times, once for each indicator.
Identical data is returned every time.
Am I missing something?
Is there a way to ensure a datasource is only populated once?

[Lech Kulikowski]

Hello,

What product, viewer and version are you use?

Thank you.

[tinytimtwo]

Hi,

I am using web.NetCore.
I was on version 2023.4.1 but have since upgraded to 2024.2.4 & that has alleviated the issue.
I have discovered though that calculated columns still seem to cause the datasource proc to be called multiple times; I resolved this by moving the calculated columns into my proc.

thanks
Tim

[Lech Kulikowski]

Hello Tim,

Thank you for the information.