Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

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 2
CNENFRNL
Community Champion
Community Champion

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!

smpa01
Super User
Super User

@Syndicate_Admin what's that TSQL query?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.