Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |