Kipper Bush on 29 Jul 2022 19:47:04
As a developer using the Microsoft platform, I would like to securely access our data sources located within an Azure VNET. Puzzlingly, they are supported for Datasets, and can refresh in the cloud but not Datamarts which are cloud native.
Data sources behind a VNET or using private links can't currently be used with datamarts; to work around this limitation you can use an on-premises data gateway.
https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-administration#considerations-and-limitations
- Comments (2)
RE: Support Datamarts behind a VNET
Good morning,We have an Azure SQL MI Server and a Power BI Premium (PPU) cluster.We migrated our Power BI cluster to the same region as our Azure Tenant.The vNET gateway as well as the Azure SQL databases are easily accessible in Power BI, but it is still very unfortunate not to be able to use them in the Datamarts (Power Query Online) given the existing limitation.this loses some of the interest of this Virtual Gateway, and having a completely cloud environment from a data point of viewHoping that this limitation can be quickly resolved.
RE: Support Datamarts behind a VNET
Any use of datamarts in my org are dead in the water unless we can BYO db that is secured behind a VNet in our Azure tenant.