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.
Hi All,
I am using Embeded power BI and in that RLS we are using. In the username() i am getting a string and i need to filter the data. In the RLS i get the list of values in the form of a string. I am getting additonal characters which i don't want in order to filter the data. Could you please help which DAX function will work.
I am getting list of values as a string: "'ABC','TDEF','HIJ'"
and i should have like this "ABC","TDEF","HIJ"
Means i need to exclude the first and last character of the double quotes and replace single quotes with Double quotes. The list of values will increase. it should work dynamically
Solved! Go to Solution.
Thank you very much. All my single quotes are coverted into double quotes
Thank you very much. All my single quotes are coverted into double quotes
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 |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |