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.
Nothing works in Power BI using Parameters, I have spent several days and the product simply doesnt work.
I am trying to do a simple task, have an end user input a date and then use that parameter in a query.
let
Source = Sql.Database("BSASQL", "BSA00"),
dbo_00RMOPENINVOICES = Source{[Schema="dbo",Item="00RMOPENINVOICES"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_00RMOPENINVOICES, each ([DOCDATE] = "&EndDate))
in
#"Filtered Rows"
Nothing but errors no matter what I do.
It appears that you have an extraneous or unclosed " at "&EndDate))
Nope,
Sorry, Like I said this whole thing is broken. Nothing works. Notice now I need a Token Literal.
Here is an example of using a parameter:
let Source = Sql.Database("localhost", "Test", [Query="SELECT * FROM dbo.Table1 WHERE Date > '" & MyDate & "'"]) in Source
MyDate is my parameter.
Sorry,
Nothing is working. I am using your exact code and still, Power BI cant work with Dates.
I am assuming your using a very old Power BI desktop that wasnt Plagued with this issue?
My parameter was text. If your parameter is actually specified as a date, use this:
let Source = Sql.Database("localhost", "Test", [Query="SELECT * FROM dbo.Table1 WHERE Date > '" & Date.ToText(MyDate) & "'"]) in Source
Aaargh,
Completely Useless, Once a report is published for others in Power BI all Parameters are gone. A user has no way at all to select a parameter.
Maybee I need to open a ticket so this service gets fixed.
I still dont understand Why Power BI is in-capable of performing Date filters.
Now I get an error that greater than or less than signs cant be used. This is insane.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |