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
:: operator for typecast in T-SQL
Introduce support for the ::type cast operator in Fabric Data Warehouse as syntactic sugar for the existing CAST(... AS type) expression. The new operator would be functionally equivalent and compile...jovanpop-msft9 minutes agoMicrosoft EmployeeNew46Views7likes2CommentsAllow calls of Fabric SQL Database stored procedures from Data Warehouse
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and even...Vojtech_Dolejsi2 hours agoNew MemberUnder Review2.9KViews13likes2CommentsPower BI - Org apps and cross-report drillthrough
This idea is a request to provide cross-report drill-through capability for org apps. This means being able to navigate between reports hosted in different org apps. The following sections detail why...TomMartens4 hours agoSuper UserNew1.3KViews24likes3CommentsMatrix Visual Missing Horizontal Scrollbar When Using Multiple Row Fields
Hello Power BI Team, I would like to report what appears to be a limitation or usability issue with the Matrix visual. I am using a Matrix with a large number of fields placed in the Rows section (...MERTARSLAN644 hours agoNew MemberNew5Views0likes0Comments