Forum Discussion
Display M query parameter value in report
Hi, I'm accessing SAP HANA views (in import mode) that have built-in parameters - in Power Query, it looks something like "{Cube.ApplyParameter, "GL_Account_Hierarchy", {"LDQFIVB5J8NN8GPFX77QEOJ7L"}}". Are there DAX functions that can access the parameter names and values so I can display them on the report as information? I.e, parameter name is "GL_Account_Hierarchy" and value is "LDQFIVB5J8NN8GPFX77QEOJ7L". Ideally, the value should display text label associated with the key, which is not very user-friendly :). Thank you in advance!
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
8 Replies
Anonymous , Are these column values?
if so you have split these first and then pivot the GL_Account_Hierarchy and its value
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hi Anonymous
If you want to see your parameters in your Report Field, you can right click your parameters and select enable load.
Then you can see your parameters in your Report Field, and use it to build visuals.
Result:
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.
Hi Anonymous
Could you load your parameter in data source into Power BI? If you couldn't, you can try to build a parameter in Power BI by Manage Parameter Function.
Here are some blogs about parameters in power bi.
Blog1: Using parameters
Blog2: Power BI Introduction: Working with Parameters in Power BI Desktop
Video: Making data source parameters easy 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.
