Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
glenmclaren
Helper II
Helper II

Access report field in M query

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 Smiley Sad

when will this functionality be available !! 

ta

 

 

1 REPLY 1
MFelix
Super User
Super User

Hi @glenmclaren ,

 

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.