Forum Discussion
Slicer-Bound Parameter DirectQuery
Hi all, I'm trying to use a DirectQuery in Power BI (Desktop, latest version) to filter a SQL Server 2019 table based on a parameter value selected via slicer. Scenario: I am using a SQL Serv...
let
source = Sql.Database("foo.bar.com", "wh",[Query="SELECT * FROM [tfm].[so.input.budget/forecast] WHERE pk = " & Text.From(#"snapshot_pk")])
in
source
Here is what my parameter looks like, maybe something is wrong here:
lbendlin
Super User
Super Userlet
source = Sql.Database("foo.bar.com", "wh",[Query="SELECT * FROM [tfm].[so.input.budget/forecast] WHERE pk = " & Text.From(#"snapshot_pk")])
in
source
That is pulling the values I expect! Thank you!
I will see a performace improvement by using value.nativequery though, for folding. Is that right?- lbendlin
no. It's already a "native" query when you put it there.