Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |