Forum Discussion
Issues with table valued function parameters, while importing into Power BI Desktop
I have table valued function (from SQL) with two 'date' type parameters (@BOP, @EOP)
@BOP is Beginning of Period
@EOP is End of Period
I need to import this tvf into Power BI. When I do it (I use SQL Server Import), PBI asks me to enter the dates for my @BOP / @EOP.
But I need to be able to use this data set for a different dates, in order not to make these data static.
Is there a way in SQL or in Power BI Desktop to keep my parameters dynamic (and not to use a specific dates when I import this dataset)?
Hi Hell-1931 ,
Try to use M parameters.
Solved: How do I pass parameters to my SQL statement? - Microsoft Power BI Community
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-lionel-msftCommunity Support
Hi Hell-1931 ,
Try to use M parameters.
Solved: How do I pass parameters to my SQL statement? - Microsoft Power BI Community
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.