Forum Discussion
Query references other queries or steps, so it may not directly access a data source
This is related to privacy settings. For lots of details see here:
https://blog.crossjoin.co.uk/tag/formula-firewall/
If there are no privacy concerns with the particular data you're working with then the easiest solution is to ignore privacy levels entirely. This can be found under the options and settings as described here:
https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels
because PowerBI firewall doesn't let you combine two queries, you need to also include the code for creating the MasterBranch table inside this query.
Once that's done, you should be able to join them. Currently firewall will be blocking this query, as it's merging two sources
Thanks for your quick response. The problem is fixed now. I used a different approach.
The 2 tables had a relationship between them with 2 columns. So I was merging the 2 tables. Now instead I created a custom col by concatenating the 2 cols in both the tables. And created a relationship between the 2 tables using this new col. This approach solved this error as well as refresh from service showing incorrect values issue.