Forum Discussion

yasmeenwilde's avatar
yasmeenwilde
Advocate II
2 years ago
Solved

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. Th...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago
    let
Source =
Oracle.Database("databasename",
[HierarchicalNavigation=true,
Query="SELECT * FROM schema.tablename#(lf) where stringcol='" & Text.From(rate) & "'"])
in
Source
lbendlin's avatar
lbendlin
Super User
2 years ago
let
Source =
Oracle.Database("databasename",
[HierarchicalNavigation=true,
Query="SELECT * FROM schema.tablename#(lf) where stringcol='" & Text.From(rate) & "'"])
in
Source
yasmeenwilde's avatar
yasmeenwilde
Advocate II
2 years ago

Thank 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 >=.