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.
Hi,
I've this query with an sql statement:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=2016")
I would like to insert the year (2016) through a parameter.
I've created the parameter "year(2016)" but I don't know how to define it in the sql statement.
Thanks in advance
Solved! Go to Solution.
hi almagir,
try the following:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=" & year)
regards,
konrad
hi almagir,
try the following:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=" & year)
regards,
konrad
Hi Konrad,
It has worked as you told me.
I've had to convert the number 2016 to text.
Thanks for your help.
Regards
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.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |