Forum Discussion
Data Firewall Issues when passing data from one query to another
I'll start by saying I can make this work in the Desktop application by ignoring the data source security settings, but this will not work when published to my powerbi gateway. I have two queries...
Greg_Deckler I have tried that approach to the best of my understanding. I created a separate query for the customer numbers from my internal DB, assigned them to a parameter and then passed the parameter into my final datalake query and I still receive the same error.
bengineer Unfortunately there is no 100% sure fire way to fix these things because everybody's queries and requirements are different. However, in theory you should be able to create a query that is essentially your first line after your let and return that step so:
let
Source = Oracle.Database(...
in
Source
Let's call this Query1. Now, in your current query, replace that Source line with:
Source = Query1