Igor Dos Santos on 01 Mar 2017 23:18:22
We the Power BI On-Premises Gateway to support these two authentication methods:
1) Authentication on-the-fly, allowing the user to enter credentials at the time the report is being accessed.
2) Enhance the On-Premises Gateway to allow pass-through of my credentials. Some customers do not want the report to be access by a hard-coded user (as we have today), and instead, they want the user to authenticate against the database backend system. This is important for customers that are highly regulated as some compliance requirements need data consumption at the database level.
Administrator on 08 Nov 2017 09:41:35
We just released Single Sign-On support when connecting to certain data sources from the Power BI Service, via the On-premises data gateway. This allows customers to map the identity of the end user consuming a DirectQuery-based report in the Power BI Service (or Mobile apps) to a domain account to use for querying the underlying data source. Initial supported sources includes SQL Server, Teradata and SAP HANA. Additional data sources coming later in CY17 include Oracle, Impala and SAP BW. Other sources, such as Spark, will be supported early in CY18. More details can be found at: https://powerbi.microsoft.com/en-us/blog/announcing-single-sign-on-support-when-connecting-to-data-sources-from-the-power-bi-service/ If you're interested in SSO support over other data sources, please feel free to create new Ideas for each of them, to help us prioritize according to customer demand. Thanks!
- Comments (2)
RE: Power BI Gateway Authentication Enhancements
If I can add to this request. The Security grain is too high for our company. You can only create a data source for the Database level and only have one Data source for that Server/DB combination. We can't have an read only account on SQL Server at the database level for all objects. We have to restrict that account to the schema level.
I would suggest a security model like Reporting Services Shared Data Sources, where I can put multiple data sources for the same Database and put a different account. Then when I associate the Data Set with a Data Source let me pick the one I want. Don't do it for me.
RE: Power BI Gateway Authentication Enhancements
Yes we already have access defined on the database why do we need to redefine it again on the PowerBI service