Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |