Loading data dynamically at runtime

[ANNOAH]

Hello,

I would like to start a query (fetch data from an API) by click on a visual (e.g. when I choose a certain value in a slicer) and append only the requested data to my existing dataset. 

The reason is that I would like to load only data that is needed to my report, since I have to handle with Big Data.

Has anyone every tried this before?

Thanks in advance and best regards

[Anonymous · Accepted solution]

Hi @ANNOAH ,

With Dynamic M Query Parameters, model authors can let report viewers use filters or slicers to set the value(s) for an M Query Parameter, which can be especially useful for query performance optimizations. With Dynamic M Query Parameters, model authors have more control over how filter selections get incorporated into DirectQuery source queries.

For reference:Dynamic M query parameters in Power BI Desktop

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.