Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@Anonymous ,
Refer if this can help: https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
@Anonymous ,
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..?
That solved it! When I put '2020' in the parameter it worked - thanks!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
68 | |
64 | |
52 | |
39 | |
26 |
User | Count |
---|---|
80 | |
57 | |
45 | |
44 | |
35 |