Forum Discussion

Hell-1931's avatar
Hell-1931
Helper II
5 years ago
Solved

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)?

1 Reply