Forum Discussion
Continued ContributorPowerQuery Firewall Error
Sorry to hear that! Do you mind posting a screenshot of your error?
Also, a few things to consider:
1. There's a firewall setting within Azure. Make sure that you have your IP whitelisted from there.
2. If your queries are complex and have multiple references or buffers, try to fold everything back into the SQL database.
3. Try changing your privacy settings. Check both Global and Report level settings and set them both to "ignore privacy levels"
4. And, lastly, Power BI does not like dynamic parameters. If you are calling an API, try to call it a different way to make it more "static"
hope that at least helps you a bit!
Go through Ben Gribaudo's Primer. Go through this https://learn.microsoft.com/en-us/power-query/data-privacy-firewall
Use single partitions. Avoid merges. Hide dynamic queries as hnguy71 suggested.
Super UserSorry to hear that! Do you mind posting a screenshot of your error?
Also, a few things to consider:
1. There's a firewall setting within Azure. Make sure that you have your IP whitelisted from there.
2. If your queries are complex and have multiple references or buffers, try to fold everything back into the SQL database.
3. Try changing your privacy settings. Check both Global and Report level settings and set them both to "ignore privacy levels"
4. And, lastly, Power BI does not like dynamic parameters. If you are calling an API, try to call it a different way to make it more "static"
hope that at least helps you a bit!