I am trying to understand the impact of migrating current on premise sql data warehouse to Azure synapse analytics from a powerBI perspective.
Azure synapse studio allows you to create a linked service which enables you to create/modify and publish powerbi reports to powerbi service.
All reports are using Import Mode connection.
Once the PowerBI report is published, how are the PowerBI datasets refreshed? Do you need to set up a gateway on a azure VM? If so, is this the only option?
In case if the network setting of the Synapse workspace (in case if suing Synapse workspace) or SQL server(in case formerly Azure SQL DW) has the property enabled for 'Allow Azure services and resources to access this workspace/resource ' Then powerbi can directly access the database without the need of a gateway.
In case if the property is disabled, then you would need to set up a gateway on a VM, whitelist the IP of that VM in the firewall rule and use it to refresh the PowerBI.
Depends on whether you're using Power BI Desktop or the Enterprise/workspace.
Desktop connections can be allowed through the Synapse firewall like direct IP address.
Workspaces can access Synapse if:
"Allow Azure services and resources to access this workspace/resource" under your Firewall tab of your Synapse is enabled. OROr you can link the Power BI and Synapse via Syanapse workspace directly as described here.
