Forum Discussion

fpennisi17's avatar
fpennisi17
Helper III
6 years ago

Formula.Firewall error triggered when calling web service with current timestamp

Hi, I'm trying to retrieve data from a public web service which requires two dates (from and to) as parameters. Every time the query run, I want to retrieve data from the web service in the time wi...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi fpennisi17 

I can't reproduce your problem.

Could you check another possible solutions to the error "Formula.Firewall"?

https://blog.crossjoin.co.uk/2017/06/26/data-privacy-settings-in-power-bipower-query-part-3-the-formula-firewall-error/

https://blog.crossjoin.co.uk/2017/07/04/data-privacy-settings-in-power-bipower-query-part-4-disabling-data-privacy-checks/

https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

fpennisi17's avatar
fpennisi17
Helper III
6 years ago

Thank you, I'll try out the suggestions mentioned in that posts and let you know.