Forum Discussion
Formula.Firewall Error when Iterating through one table to create another
Hello Anonymous
the solution to your problem was that you have to put every code to access your API in one query. Means that some data access query have also be placed there. And there your question was If it would possible to reuse a part of bigbig query.
The solution I gave you is a realy basic version of how it could work. To explain it a bit further
in your big query you hava "let" and a "in". When you now have to include a data access query to this big query, do like that
YourQueryNameToBeIntegrated = //and here you put your query let ..... final= .... in finalnow to be able to steer how this query is access, you can modify your output of your bigbig query as a record like this
finalresultbigbigquery = .... in [FinalResult= finalresultbigbigquery, YourIntegratedoldQuery = YourQueryNameToBeIntegrated]this enables you to use your bigbig query in two ways.. meaning the final result AND your integrated old query (that accesses basic data). Just invoke the bigbigquery whether like bigbigquery[FinalResult] OR bigbigquery[YourIntegratedoldQuery].
With this scenario you can reuse the coded inputed in your big query.
Hope its clearer now
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
suJimmy801, thanks for your post.
You say "So the only solution here for me seems to be or to switch of the Firewall function"
How can the Firewall function be ignored ? I guess by setting File/Options & Settings/Options/Global/Privacy = “Always Ignore Privacy Level settings” in Power BI desktop?
The issue is that with this setting Scheduled refresh for this query does not work (it fails with the same firewall error)
.
I meant solutionS...
One is ignoring the setting the other is to create only one query
🙂
Jimmy
Jimmy801if I merge the queries, if a new query needs the All_Boards table, I will need to copy the code there again, isn't it?
Hello Anonymous
not forcidly. What you can do, create a central basic query. In the output you specify a record with all extracts you need. So for the handover to Power BI you create afterwards a new Query that just uses this syntax YourNewQueryName[Result]. For referencing only the AllBoardsPart use this syntax YourNewQueryName[Allboards]. Here the basic practical example.
let Quelle = let test = {1,2,3} in test, test = List.First(Quelle) in [Result= test, AllBoards= Quelle]What do you think of handling like that?
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyJimmy801,I am not sure I understand your code. Can you modify the code to how how the table created by the All_Boards query can be used by the All_Boards_All_Sprints query without the firewall error ?
Hello Anonymous
the solution to your problem was that you have to put every code to access your API in one query. Means that some data access query have also be placed there. And there your question was If it would possible to reuse a part of bigbig query.
The solution I gave you is a realy basic version of how it could work. To explain it a bit further
in your big query you hava "let" and a "in". When you now have to include a data access query to this big query, do like that
YourQueryNameToBeIntegrated = //and here you put your query let ..... final= .... in finalnow to be able to steer how this query is access, you can modify your output of your bigbig query as a record like this
finalresultbigbigquery = .... in [FinalResult= finalresultbigbigquery, YourIntegratedoldQuery = YourQueryNameToBeIntegrated]this enables you to use your bigbig query in two ways.. meaning the final result AND your integrated old query (that accesses basic data). Just invoke the bigbigquery whether like bigbigquery[FinalResult] OR bigbigquery[YourIntegratedoldQuery].
With this scenario you can reuse the coded inputed in your big query.
Hope its clearer now
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy