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

[Hell-1931]

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 · Accepted solution]

Hi @Hell-1931 ,

Try to use M parameters.

Power Query (M) – Passing Parameters dynamically to a SQL Server Query - Reporting/Analytics Made ea...

Solved: How do I pass parameters to my SQL statement? - Microsoft Power BI Community

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.