PowerQuery paremeter in DirectQuery mode

Anonymous — Fri, 18 May 2018 11:32:03 GMT

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

Re: PowerQuery paremeter in DirectQuery mode

v-jiascu-msft — Tue, 22 May 2018 01:58:48 GMT

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

topic PowerQuery paremeter in DirectQuery mode in Developer

PowerQuery paremeter in DirectQuery mode

Re: PowerQuery paremeter in DirectQuery mode