Forum Discussion
Syndicate_Admin
4 years agoAdministrator
How to work with parameters between T-SQL Server and power BI
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
2 Replies
- CNENFRNLCommunity Champion
Since your sql works well on the SQL Server end, you can use Value.NativeQuery() with original paramters to retrieva result set.
- smpa01Community Champion
Syndicate_Admin what's that TSQL query?