Microsoft has announced the availability of the new feature for Power BI gateway. IN particular :
- UPN mapping.
- SAP Business Warehouse Server
- Get Data Feature
To activate this new feature we nedd to install the latest Power BI gateway for Enterprise use.
User with Analysis Services model and the Power BI Gateway will be able to set up their own UPN mapping rules.
UPN Mapping enables gateway admins to apply custom security rules by mapping users’ cloud identity to specific on-prem roles or identities, via Effective User name and CustomData properties on an AS connection.
This feature will be rolled out in 2 phases: Using Effective User name, which is now available, and using CustomData property, which will be available soon.
To Create new mapping rules:
- go to the “Manage Gateways” option from your Power BI dashboard, and then choose the Gateway and Analysis Services server to which you want the rules to be applied.
- Click on the Users tab and notice the new “Map user names” option.
- This will open the UPN mapping rules pane and you can start creating rules:
These rules will be applied to the selected data source only and not the whole Gateway. Please note that you need to be a Gateway Admin to set up or modify these rules.
Connecting to SAP Business Warehouse Server using Power BI Gateway – Enterprise
Microsoft is adding support for refreshing datasets and reports that include SAP Business Warehouse Server data using the gateway. With this gateway release you will be able to set up a scheduled refresh using your Enterprise Gateway, by choosing the SAP Business Warehouse option in your data source configuration for your Gateway.
Power bi is supporting Enterprise Gateway connected Analysis Services models directly from within the Power BI “Get Data” experience, which means you can start creating your Gateway-configured AS data sources right from within the Power BI service.
Analysis services Connector
If you are still using the AS connector, note that support for SQL Server Analysis Services Connector has ended, and databases connected using this method no longer appear in the Get Data experience. Only databases connected using Power BI – Enterprise Gateway appear.