Forum Discussion
Query Parameter Date does not show up in Filter Rows
Dear Power BI Fellows I have a table which I need to filter using two date parameters (max date and min date). I get the dates from SQL server as List Queries. I create parameters which use Li...
Hi izhilin,
I guess you have added those 3 columns above your filtered row step from different tables in your report.
So if possible, move the filtered rows steps to before the column additions. i.e. Next to the source step.
Hopefully, that should solve the issue
Regards,
Thejeswar
Thanks for the reply.
Actually the 3 added columns are calculated from the same table.
Anyway, I moved the Filter step right after the Source step. However, I still get this Formula.Firewall error!
I understand that both parameters filterMinDate and filterMaxDate come from SQL Queries. But I still cannot figure out the "it may not directly access a data source".
Why then is there an option to use Query as source for parameter at all?