Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I've got the following query and it works fine. The lines below are from the advanced editor:
let
Source = Odbc.Query("dsn=DW", "SELECT * FROM mwrdw.dbo.as_sales WHERE fiscyear >= 2020 ")
in
Source
I'm trying to replace the fiscyear with a parameter value but I'm failing. I've set up a new parameter ("Parameter1") with a current value of 2020. I've then changed the text in the advanced editor to:
let
Source = Odbc.Query("dsn=DW", "SELECT * FROM mwrdw.dbo.as_sales WHERE fiscyear >= "Parameter1" ")
in
Source
I get a "Token Comma expected" error. I've tried a couple of variations with no success. The fiscyear field in the source contains four digit years stored as numbers.
I'm trying to set up a parameter that I can pass to the service allowing me to edit the fisc year there. The table stores a huge amount of data (too much for the desktop application that gives a memory error when too many years are loaded) but Power BI service will handle this.
If I can get the parameter to work I can then have a much smaller desktop filesize while I work but pass many more years to the file in the service.. I hope I've explained that right!
Solved! Go to Solution.
@Noyer ,
Refer if this can help: https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
@Noyer ,
Refer if this can help: https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
Hi
Thanks for the quick reply. Using the link you suggested I amended the advanced editor to:
let
Source = Odbc.Query("dsn=DW", "SELECT * FROM mwrdw.dbo.as_sales WHERE fiscyear >= "&Parameter1&" ")
in
Source
However I now get the following error:
Expression.Error: We cannot apply operator & to types Text and Number.
Details:
Operator=&
Left=SELECT * FROM mwrdw.dbo.as_sales WHERE fiscyear >=
Right=2020
I don't know what that means..?
You are passing as text parameter, it needs number
That solved it! When I put '2020' in the parameter it worked - thanks!
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |