Limit loading amount of simulation data

[bvdw]

Hello everybody,

I am building a dashboard for a production plant. For this plant simulations are run and this simulation data is stored every 10 minutes. These simulations are given a run ID as unique identifier. I want to compare them to actual performance of the plant. The problem is that this is a huge amount of data. I wanted to tackle this problem by designing a prompt page in which a run ID can be selected, so that only data for this simulation will be loaded into the dashboard. I learned that prompt pages are not implemented in Power BI. 

Is there another way to limit the data loaded into Power BI in order to be able to compare simulation data with actual performance?

Thanks in advance!

[bvdw]

Hello everybody,

I am building a dashboard for a production plant. For this plant simulations are run and this simulation data is stored every 10 minutes. These simulations are given a run ID as unique identifier. I want to compare them to actual performance of the plant. The problem is that this is a huge amount of data. I wanted to tackle this problem by designing a prompt page in which a run ID can be selected, so that only data for this simulation will be loaded into the dashboard. I learned that prompt pages are not implemented in Power BI. 

Is there another way to limit the data loaded into Power BI in order to be able to compare simulation data with actual performance?

Thanks in advance!

[Stachu · Accepted solution]

if you create a parameter in the query editor and save it as a template it will ask for te parameter each time you open the file

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

problem is that once you publish into the service it remembers the value, user cannot change it