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
Eventstream MQTT broker source: V3.1.1 support
The Eventstream MQTT broker source supports connections with public MQTT brokers that offer MQTT V5 support. Please offer support for V3.1.1 too, because this is still a valid and widely used ver...svelde58 minutes agoSuper UserCompleted1.4KViews6likes4CommentsGet data from Apache Kafka topics via private networking
Current prerequisites limit to public Kafka instances which is not feasible for most enterprise customers. When will this limitation be lifted so that it can be used in private network setups, for ...Jugi1 hour agoMicrosoft EmployeePlanned3.5KViews2likes3CommentsSet default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg9 hours agoNew MemberNeeds Votes7.8KViews1154likes104CommentsTable Visual — Rounded Corners and Pill-Style Cell Backgrounds
Add the option to display cell background colors as rounded rectangles or pill-shaped labels within the native Table visual. Currently, applying a background color fills the entire cell with a solid...urawizardharry10 hours agoRegular VisitorNew10Views0likes0Comments