How to work with parameters between T-SQL Server a...

Syndicate_Admin · ‎11-30-2021

good afternoon experts.

First of all thank you very much for offering an opportunity to have a day or solve problems through this medium.

I'm starting with this Microsoft product and I have a lot of doubts about it.

This time, my case is as follows:

I'm passing a query thrown in T-SQL Server to power bi, but that query has a pair of date-type parameters, in the sql server it runs well, but you do not work those parameters in Power BI.

I would like you to please support me for this case.

Thanks a lot.

Note: if you want more additional information I am available

CNENFRNL · ‎12-01-2021

Since your sql works well on the SQL Server end, you can use Value.NativeQuery() with original paramters to retrieva result set.

Chris Webb's BI Blog: Passing Parameters To SQL Queries With Value.NativeQuery() In Power Query And ...

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!