Forum Discussion
Snowflake Tables Not Merging in Service
Hi etane ,
Adjust the Data Privacy Level of the Snowflake data source to Organizational or Public under Gateway connection settings. moving file of IPs, so then the most dynamic way I’ve found to manage this is with whitelisting the Azure Services Tags in Snowflake. The best place for your vendor to get this list from is Microsoft's public documentation, which can be scripted by them into a process to update a Snowflake Network Policy.
If you are still facing this issue you can rasie ticket for immediate support.
https://go.microsoft.com/fwlink/?linkid=2230908
Thankyou, @ mohitkumawat, for your response.
Hi etane,
Thankyou for the followup.
Based on my understanding, to enable Power BI Service to connect to and refresh Snowflake datasets reliably, please ensure that the following Azure service tags (West US region) are allow listed or included in the Snowflake network policy.
Required service tags:
- AzureConnectors.WestUS (important, as it is used by Power Query Online and managed connectors)
- PowerBI.WestUS
- PowerQueryOnline.WestUS
- PowerPlatformInfra.WestUS
Optional service tags (if staging or blob storage is used):
- Storage.WestUS
- GatewayManager.WestUS
If Snowflake does not natively support service tag syntax, extract the IP ranges corresponding to these tags from Microsoft’s published JSON file and update the network policy automatically. This JSON file is refreshed weekly. Snowflake network policies can be scripted to refresh the allowed IP prefixes automatically. After adding these tags or their IP ranges, please test a Power BI Service refresh. The connection should succeed without further IP rejections.
If the refresh still fails after adding these tags, please raise a Microsoft support ticket using the link:Microsoft Fabric Support and Status | Microsoft Fabric
Additionally, please refer to the links provided below:
Azure service tags overview | Microsoft Learn
Managed connectors outbound IP addresses | Microsoft Learn
Connect to Snowflake with Power BI - Power BI | Microsoft Learn
We hope that the information above will help to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.
Hello.
Thank you for your detailed reply.
I have some updates. We managed to get Snowflake tables to merge and refresh. in PBI Serivce. After a prompt from MSFT LTIMINDTREE, we used the Snowflake connector without Data Gateway. With this method, the Snowflake tables are able to merge and refresh in Service.
So, I started development of a new dataflow. I merged Snowflake tables with Salesforce tables, not an issue. Then, I pulled a QAD ERP table via SQL Server db connection. I didn't even do anything with this table. Just, once it's loaded, I refreshed the dataflow, I get the error message: On-Prem execution not supported for entity ... since it refers to another entity.
Also, what's intereting is even after I deleted the QAD table and removed the connection in Service's Power Query's Manage Connection, the dataflow still wouldn't refresh.
Help?
Help?