Brent_Wodicka
7 years agoNew Member
Status:
Needs Votes
PowerBI Gateway - Add Azure SQL Database as a datasource connection type
We're using PBI gateways to secure traffic / queries to Azure SQL Database. We are doing this by deploying the gateway on a VM in Azure, restricting access to the DB to sources on that Virtual Network with a VNET firewall rule. So, PBI datasources that use this Azure SQL DB have to run through the gateway. The PBI gateway currently only allows a "SQL Server" connection type which is limited in a few ways: 1) Windows Auth doesn't work in this scenario - not supported, Azure SQL isn't part of the domain even though we can add add AAD users who have been replicated as DB users in Azure SQL 2) Traditional SQL connections can't support authenticating with an Azure Service Principal - many other services (Data Factory, etc.) support this authentication model. So, the ask is to please consider adding a new data source type "Azure SQL" which would support authenticating with an AAD App / Service Principal. This would allow us a more cloud-friendly authentication option (better than typical SQL credentials username/password) when securing our Azure SQL Database datasources in this way. Even better, allow the configuration of these credentials to ready from KeyVault as an optional configuration setting.
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Allow report creators to download their Own PBIX even when Downloads are restricted at tenant level.
In the current Power BI permission model, PBIX downloads are controlled exclusively through tenant‑level export settings and workspace roles. This creates a significant limitation for multi‑agency or...pbiuserNC4 hours agoNew MemberNew8Views0likes0CommentsNative KPI Governance, Ownership and Business Change Impact in Microsoft Fabric
Native KPI Governance, Ownership and Business Change Impact in Microsoft Fabric Idea In enterprise analytics, one of the biggest challenges is not creating a KPI, but ensuring that everyone agrees ...kulkarnigauri38 hours agoNew MemberNew3Views0likes0CommentsEnable writing PowerQuery type time (from Dataflow Gen2) to Warehouse type time
Currently the UI throws an error while I am trying to write Data typed as "time" in Power Query to a Fabric Warehouse. I would prefer to import data typed as "time" in Dataflow Gen2 PowerQue...pyd4life11 hours agoAdvocate INew105Views2likes1Comment