Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
espo4life
Helper I
Helper I

SQL Table Value Function with Parameters

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!

 

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

That worked beautifully. Thank you!!

TomMartens
Super User
Super User

Hey @espo4life ,

 

this article describes what you are looking for:

https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-sql-native-query-wi...

 

Hopefully, this helps to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.