Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |