topic Re: Issues with table valued function parameters, while importing into Power BI Desktop in Developer

Issues with table valued function parameters, while importing into Power BI Desktop

Hell-1931 — Thu, 11 Mar 2021 04:55:23 GMT

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

v-lionel-msft — Mon, 15 Mar 2021 02:11:30 GMT

Try to use M parameters.

Best regards,
Lionel Chen

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