Loading data dynamically at runtime

ANNOAH — Wed, 26 Oct 2022 10:31:29 GMT

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

Re: Loading data dynamically at runtime

Anonymous — Thu, 27 Oct 2022 07:43:38 GMT

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.

topic Re: Loading data dynamically at runtime in Developer

Loading data dynamically at runtime

Re: Loading data dynamically at runtime