Forum Discussion
decimal parameter in custom sql when connecting to oracle from power query
Hello community members,
I'm looking for the correct syntax for decimal parameter. The below m script below works if rate is a text parameter. It produces an error if rate is a decimal parameter. The condition needs to be stringcol >= pID
This is a directquery connection. I have a huge table with million rows of data. I am trying to get a small subset of data into power query. I've googled and searched through the community. I found answers for text and datetime parameters but unable to find decimal parameter. Please help.
let
pID=rate,
Source =
Oracle.Database("databasename",
[HierarchicalNavigation=true,
Query="SELECT * FROM schema.tablename#(lf) where stringcol='"&pID&"'"])
in
Source
let Source = Oracle.Database("databasename", [HierarchicalNavigation=true, Query="SELECT * FROM schema.tablename#(lf) where stringcol='" & Text.From(rate) & "'"]) in Source
2 Replies
let Source = Oracle.Database("databasename", [HierarchicalNavigation=true, Query="SELECT * FROM schema.tablename#(lf) where stringcol='" & Text.From(rate) & "'"]) in SourceThank you so much lbendlin this works when I changed the = to >=.
On my original script above, I received a syntax error when I changed = to >=.
