hmbouk / Monday-paginated-board-PBI-query

MIT License
3 stars 1 forks source link

Error: Formula.Firewall: Query 'Monday Board' (step '2nd_Page_Table_Updated') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. #3

Open 1nsoul opened 1 month ago

1nsoul commented 1 month ago

Hello,

Thanks for the powerbi code. When I go through the Applied Steps in the Monday Board example, the tables are generating successfully. BUT when I get to the Combined_Table1 step I receive the following error. Can you help please?

Formula.Firewall: Query 'Monday Board' (step '2nd_Page_Table_Updated') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

hmbouk commented 1 month ago

Fortunately, the solution is simple. The following URL has some more detail but to solve this you need to ignore privacy levels in your Power BI file. In Power BI, go to File=>Options and Settings=>Options and set the Ignore Privacy Levels option.

https://community.fabric.microsoft.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-so-it-may-not/m-p/18619

Howard Bouk

From: 1nsoul @.> Date: Wednesday, March 27, 2024 at 9:47 AM To: hmbouk/Monday-paginated-board-PBI-query @.> Cc: Subscribed @.***> Subject: [hmbouk/Monday-paginated-board-PBI-query] Error: Formula.Firewall: Query 'Monday Board' (step '2nd_Page_Table_Updated') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. (Issue #3)

Hello,

Thanks for the powerbi code. When I go through the Applied Steps in the Monday Board example, the tables are generating successfully. BUT when I get to the Combined_Table1 step I receive the following error. Can you help please?

Formula.Firewall: Query 'Monday Board' (step '2nd_Page_Table_Updated') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

— Reply to this email directly, view it on GitHubhttps://github.com/hmbouk/Monday-paginated-board-PBI-query/issues/3, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ADGMAVW4HT4LC6OIW5TXDBDY2K5WZAVCNFSM6AAAAABFK5I2R2VHI2DSMVQWIX3LMV43ASLTON2WKOZSGIYTAOBVGQ3DQNI. You are receiving this because you are subscribed to this thread.Message ID: @.***>