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.
I have a Table-Value Function that I want to use as a data source and have it parameterized (even if I have two static parameters). The signature is
SELECT * FROM [dbo].[fnCUSTCLUBPLAN] (
<@PeriodStart, datetime2(7),>
,<@PeriodEnd, datetime2(7),>)
I imported it into Power BI with hardcarded dates and the editor shows it as
= dbo_fnCUSTCLUBPLAN(#datetime(2000, 1, 1, 0, 0, 0), #datetime(2000, 6, 5, 0, 0, 0))
Can anyone point me in the right direction?I have a parameter named "Parameter1" that is a date/time type.
Thanks in advance!
Solved! Go to Solution.
Hi @espo4life ,
You can create 2 query parameters to filter the data based on the date field, please refer the contents in the following links to achieve it.
Working with Parameters in Power BI Desktop
How do I pass parameters to my SQL statement?
Best Regards
Rena
Hi @espo4life ,
You can create 2 query parameters to filter the data based on the date field, please refer the contents in the following links to achieve it.
Working with Parameters in Power BI Desktop
How do I pass parameters to my SQL statement?
Best Regards
Rena
That worked beautifully. Thank you!!
Hey @espo4life ,
this article describes what you are looking for:
Hopefully, this helps to tackle your challenge.
Regards,
Tom
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |