Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Query referring to another query

I'm getting my data from an API (GraphQL) that requires a token. There is a different token every couple of days, so the query should use a different token each time. (I can't use a static parameter for that).
I have another API query that gets the token whenever it's refreshed. (This query only has one value which is the token)
I'm trying to connect between the two queries so the data will refresh automatically but I keep getting the Formula.Firewall error (Query references other queries, so it may not directly access a data source.).
Is there a way to automatically get the updated token to connect to the API? (without manually change the token each time)

Screenshot 2023-06-07 at 3.15.29 PM.png



Resolver II
Resolver II

Can you turn the Token into a Parameter (Right click on the single value and Drilldown (must be ABC)) and utilise it that way rather than as a query?

For the error message I had a similar issue with passing parameters to SQL and had to change my privacy settings in order to make it work....


This started "randomly" as last week it wasn't an issue so guessing there has been some sort of update/change somewhere that now means this has to be ticked.

@JamesRobson Thank you for the response! 

Unfortunately, I don't want to change the privacy settings, so I can't use that option. 

Regarding the first option you suggested, I tried to do so, but I keep getting the same error. After the drill down, how can I turn the value into a parameter?

Once you have done the drill down you can then type the name of that into your original query; for example I've created a parameter (drill down) that I renmaed ParameterName and then used it to filter a column......


Let me know if that doesn't make sense 🙂

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors