Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
let
Source =
Oracle.Database("databasename",
[HierarchicalNavigation=true,
Query="SELECT * FROM schema.tablename#(lf) where stringcol='" & Text.From(rate) & "'"])
in
Source
let
Source =
Oracle.Database("databasename",
[HierarchicalNavigation=true,
Query="SELECT * FROM schema.tablename#(lf) where stringcol='" & Text.From(rate) & "'"])
in
Source
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 >=.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.