PowerQuery paremeter in DirectQuery mode

[Anonymous]

Hi, 

I am trying to setup a parameter to use with a directquery datasource, which uses one of the source database columns in the parameter as a query.  I am able to create the parameter with a list  of values, and it is passing the parameter ok. However when I switch to using a query based parameter I get the following error: Formula.Firewall: Query 'Filtered Vendor List' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. I need to have a dynamic parameter that uses values from the database rather than a fixed list which needs maintaining separately.  I have seen other posts which mention the lack of caching in directquery to enable parallel use of data from the same data source.  Not sure if this is the same issue with parameters. 

Can you help? 

Dan

[v-jiascu-msft]

Hi Dan,

There is a solution here. But that couldn't be the way you want. How about creating a view in the database? Then you just need to get the data from a view. Because the data and filters are all in the database.

Best Regards,

Dale