Access report field in M query

[Anonymous]

hello all

i have a M coded query which has this line in it

{Cube.ApplyParameter, "ip_EndDate", {Date.From(ipFromCycleDate)} }

i want to replace the parameter ipFromCycleDate to be a variable based on somewhere on the report.

this way, I can dynamically pass a value through to my query.

all because you cannot change PBI parameters using the online BPI service 

when will this functionality be available !! 

ta

[MFelix]

Hi @Anonymous ,

This feature is not possible on PBI, you cannot pass values from the report to the Query, the reports only read query information.

What you can do is create a parameter table in wich you can select the value to be upload in the query, hovewer this change will be usable on the desktop version.

One option is to create a What if scenario that creates a parameter list and measure that you can use on your report and filter your data, however you have to make your query data the full information and not filter out.

Regards,

MFelix