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 have created a parameter on Posting Period: Values for posting period are 001,002,003,.........011,012.
When I create a parameter and enter the current value ass "001" and click on OK, it changes to "1".
The data in my database is 001 and passing just 1 is giving me an error.
I need to change the parameter data type to Text(ABC) rather than whole number(123) to accept 001 as value and pass to the DB to fetch the data.
Can someone please let me know how to achieve this?
Thanks
Poojitha
Solved! Go to Solution.
Hi @Anonymous ,
When you create "Posting Period" parameter, it is needed to change the type to "Text", not "Any".
You can modify the type according to the following steps:
1. Manage Parameter.
2. Change the Type of Parameter from "Any" to "Text".
3. Enter "001" to current value.
4. OK.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
When you create "Posting Period" parameter, it is needed to change the type to "Text", not "Any".
You can modify the type according to the following steps:
1. Manage Parameter.
2. Change the Type of Parameter from "Any" to "Text".
3. Enter "001" to current value.
4. OK.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.