Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
73 | |
42 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |