Forum Discussion
Dynamic REST Parameter in Power Query Editor
Hi gracz ,
I would solve this by turning the firewall off.
This is exactly the case where in my eyes, this is justified.
ImkeF I didn't think of that. And I appreciate the, rare as they may be, justified cases for firewall exceptions and the like. However, that's not an option as the organizational structures around me won't permit it.
Your solutions implies that there's some property (or properties) of the file such that it doesn't play nice with the firewall when it's passed on to another user. Do you have an idea of what such properties might be in play here? For instance, the credentials for the REST API don't change when I pass it on to other users so that's unlikely to be a culprit. If you could identify some possibilities I could then maybe more surgically address the issue in the file, bypassing the need to modify the firewall. Thoughts?