cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Formula.Firewall I

I have an OData query, Stg_ProjectSiteDatabase, that extracts rows from a SharePoint online database, including URLs for subsites. I have a second query that is attempting to add a column, looping through the rows of Stg_ProjectSiteDatabase, calling an OData function to get SharePoint online list ("Issues") data for each subsite using the siteUrl field. However, despite splitting the queries per this article, I am still getting this error:

 

Formula.Firewall: Query 'Issues' (step 'Invoked Custom Function') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

 

The function 

Here's the second query:

 

let
    Sites = Stg_ProjectSiteDatabase,
    #"Invoked Custom Function" = Table.AddColumn(Sites, "IssuesTable", each GetSPOnlineProjectIssues([SiteURL]))
in
    #"Invoked Custom Function"

I haven't found a solution for this. I tried putting the Stg_ProjectSiteDatabase data in a List, then looping through it to call the function, but same issue.

1 ACCEPTED SOLUTION

They just need to be set to where if you are using multiple data sources, queries combining between them have the appropriate rights

 

Yes, the encapsulation should work in your case, and this article helped my find that solution: https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/

 

Thanks,

View solution in original post

4 REPLIES 4
blopez11
Super User
Super User

I've run into this so many times, especially when using web service data sources

The way I have got around this is by encapsulating the staging query in a function and having the subsequent query call the function instead of referencing the staging query

 

Also make sure your data sources have the correct privacy settings

 

Hope this helps

 

Anonymous
Not applicable

Thank you for the suggestion, I will try encapsulating the staging query in a function.

 

Is there a specific value needed for the data sourc privacy setting, or does it simply need to be consistent across data sources? In this case, I only have one data source.

They just need to be set to where if you are using multiple data sources, queries combining between them have the appropriate rights

 

Yes, the encapsulation should work in your case, and this article helped my find that solution: https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/

 

Thanks,

Anonymous
Not applicable

Thank you so much, that worked!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors