Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mkjit256-outloo
Frequent Visitor

Passing bearer token generated in one query to another query returning a Formula.Firewall error

Hello,

I was able to get an authorization token, which changes every hour, by providing a username and an api_key in the following query mkjit256outloo_0-1676300091499.png:

 

 

let
   username = "xxxxxxx",
   api_key = "xxxxxxxxxxxx",
   #"BaseURL" = "xxxxxxxxxx",
content =
       "{
           ""username"" : """& username &""",
           ""api_key"" : """& api_key &"""
       }"
    ,
Source = Json.Document(
       Web.Contents(
           #"BaseURL",
           [
               RelativePath = "/xxxxxx/v1/authorize",
               Headers=[
                       #"content-type" = "application/json",
                       #"cache-control" = "no-cache"
               ],
               Content=Text.ToBinary(content)
           ]
           )
   )
in
    Source[token]

 

 

 

Then i have a single column table:

ID
1xxxx-xxxxx-xxxxxx-xxxxx
2xxxx-xxxxx-xxxxxx-xxxxx

 to which i would like to add a new column, using an invoked custom function. The function has the ID column as input, and should be also provied by the token: the body of my function is : 

 

 

(id as text)=>
let
   #"BaseURL" = "xxxxxxxxxx",

Source = Json.Document(
       Web.Contents(
           #"BaseURL",
           [
               RelativePath = "/xxxxxx/v2/xxxxx?id=" &id,

               Headers=[
                       #"Authorization" = "bearer " &token
               ]

   )
in
    Source

 

 

but when applying this function on the table, i am getting the following error:

 

Formula.Firewall: Query 'function_name' references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

 

 

 

 - How is it possible to achieve my goal of passing the generated token in one query to another query? 
PS: I am generating the token in one query and then passing it to another query instead of combining the two query into one, as i am using the same token for several queries within my model. 

1 ACCEPTED SOLUTION

The thing is that privacy levels are the cause for your Formula.Firewall error - and are a good way to warn you that you are combining data from different sources (maybe you don't trust them all) -> "ignoring privacy levels" (warning: are you sure? ARE YOU REALLY SURE?) 🙂 should clear the error and allow you to continue with the exploration.

 

I tested your snippets locally with minor changes and they work with "ignore privacy level" set.

 

P.S. Don't know how many rows you will have in that single column table, but each row will hit the api endpoint with a request... fast. If you have MANY rows and control over the api, after testing if you get not so good performance, one option could be to batch together multiple rows in a single request.

View solution in original post

4 REPLIES 4
mkjit256-outloo
Frequent Visitor

Thanks for your reply

The single column table, should not exceed the 100 rows (has two rows currently 😀 ), but wondering now how it is possible to batch together multiple rows in a single request?

ams1
Super User
Super User

Hi,

 

I'm guessing you want to solve this WITHOUT ignoring privacy level settings, right? 😀

 

Thanks for reaching out...

The report i am building now is to explore how to the API requests from Postman to Power Query, and it will not published to a shared workspace. That is why i have hardcoded the username and api_key for now.
The next step will be to create a custom connnector, and at that step Privacy levels settings will be considered.... 

Hope i did answer you question/comment.

The thing is that privacy levels are the cause for your Formula.Firewall error - and are a good way to warn you that you are combining data from different sources (maybe you don't trust them all) -> "ignoring privacy levels" (warning: are you sure? ARE YOU REALLY SURE?) 🙂 should clear the error and allow you to continue with the exploration.

 

I tested your snippets locally with minor changes and they work with "ignore privacy level" set.

 

P.S. Don't know how many rows you will have in that single column table, but each row will hit the api endpoint with a request... fast. If you have MANY rows and control over the api, after testing if you get not so good performance, one option could be to batch together multiple rows in a single request.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors