Forum Discussion

izhilin's avatar
izhilin
Frequent Visitor
8 years ago

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...
izhilin's avatar
izhilin
Frequent Visitor
8 years ago

Okay, so I managed to get the parameter to appear in the date filter by changing its type to Date/Time.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

However, now I get this error:

Formula.Firewall: Query 'Invoice' (step 'Filtered Rows') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I found a blog post that explains how to fix this in Excel Power Query: https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/, but I am unable to reproduce it in PBI.

 

Please help.

 

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    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

    • izhilin's avatar
      izhilin
      Frequent Visitor
      8 years ago

      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?