April 23, 2024

PowerBI Formula.Firewall Error: how to handle

I share here how I have solved this PowerBI error.

Error description

I got following error in my PowerBI Jira Template:
Formula.Firewall: Query 'GetIssuesTable' (step 'Issues') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Solution


let
    Fields=GetFields,
    IssuesTable = GetItems(null,Fields),
in
    IssuesTable

Quick (dirty?) fix would be to change in the PBI file options-> Privacy-> Always ignore Privacy Level settings


Alternatively as cleaner fix, I have merged the two queries in one i.e. moved the code of the Query GetFields inside this problematic query.

No comments:

Post a Comment