Forum Discussion
PowerBI snowflake refresh fails
Hello Team, I have published a dataset which works on my local desktop but fails on services with below error: Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessErr...
I'm not sure if this is your situation but maybe your snowflake instance has IP whitelisting and when you publish/manually refresh, the data is being requested by your whitelisted IP, but when the scheduled refresh is used, a microsoft IP address is requesting the data and is not whitelisted.
You can attempt to troubleshoot this by putting a power bi gateway on your network and connecting to snowflake through that gateway. Then all queries to snowflake should come from your IP.