Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Is there a way to change a string parameter to replace certain characters and then save this to a new parameter, such that if the first parameter is changed then the second one automatically updates as well?
Solved! Go to Solution.
Hi! I was trying to create a parameter that was based off a user given string. This string is then passed into an sql query with a bunch of special characters escaped. I did this through passing it to the SQL query like "% stringName %" and then adding a bunch of .textReplace(). Like this: "% stringName%.textReplace().textReplace().textReplace() %".
I was trying to get to a way of escaping those characters, this was the best solution I found
you cannot dynamically create parameters. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Hi! I was trying to create a parameter that was based off a user given string. This string is then passed into an sql query with a bunch of special characters escaped. I did this through passing it to the SQL query like "% stringName %" and then adding a bunch of .textReplace(). Like this: "% stringName%.textReplace().textReplace().textReplace() %".
I was trying to get to a way of escaping those characters, this was the best solution I found
I'm still not clear what you are trying to achieve. Can you give an example?
The scenario was:
User wants to know the count of a certain string based on an SQL query
That string my contain single and double quotes, and [ or ]
These needed to be escaped automatically prior to being passed into the sql query, and turned into a %
The user needed to be able to change the string on demand and then have power bi update the tiles
I was trying to find out how to be able to pass in this string as a parameter to the sql query in power bi, with those charcaters automatically escaped
In order to do this, I passed it into the query through a parameter, then used .textReplace() a bunch of times to escape all those characters
I was originally trying to use a power bi M query to achieve this, however the parameter wasn't being successfully updated
User | Count |
---|---|
83 | |
77 | |
70 | |
69 | |
54 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |