Power BI Tutor

We are happy to announce that we have just released the December update for the on-premises data gateway (version 3000.154.3). This update brings the on-premises data gateway up to date with the December release of Power BI Desktop. Download:  On-premises data gateway December release This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the gateway will go through the same query execution logic/run-time as in the December version of Power BI Desktop.

We are happy to announce that we have just released the July 2022 update for the On-premises data gateway (version  3000.134.9 ). This update doesn’t include changes to the data gateway application. Go to  On-Premises Data Gateway (standard Mode) download page. Go to  On-Premises Data Gateway (Personal Mode) download page. Compatible with July Power BI Desktop

Recently replaced the “manage gateway” experience with a new interface, making it easier to manage your gateways and data sources. With this new experience, you also get the ability to manage and create the Vnet gateway and use the recently released additional security roles. How to create new data sources Navigate to powerbi.com Navigate to the  Manage gateways  page To create a new data source, click on the  New  button in the top ribbon Select the gateway you want to create a data source for and give the data source a name Select the  Data source type . In this example we are using SQL Add the  Server  and  Database  and fill out the credentials Click on  Create  to create the data source. On success you see a message that the data source was created successfully Optionally, you can also set  Single Sign-On  for specific data sources and the  Privacy level How to view/change setting of data sources Select one of th...

We are happy to announce that we have just released the April 2022 update for the On-premises data gateway (version  3000.122.7 ) Download On-Premises Data Gateway (standard Mode). Download On-Premises Data Gateway (Personal Mode). Compatible with April Power BI Desktop  This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/run-time as in the April Power BI Desktop version.

We are excited to announce additional gateway security roles for Power BI! These additional security roles allow for more granularity in assigning roles for the gateway. The new change is that non-admins of the gateway can be allowed to create connections (data sources) on the gateway. This way, your gateway admins are not the bottleneck anymore for creating connections (data sources). Security roles There are three security roles for the on-premises data gateway. When you install an on-premises data gateway, you automatically become the admin of the gateway. There can be multiple admins on the gateway. The three security roles for the on-premises data gateway are: Admin : An admin can manage and update the on-premises data gateway. An admin is allowed to create connections (data sources) on the gateway. An admin is allowed to manage (add/delete) users with admin, connection creator, and connection creator with sharing roles on the gateway. An admin can also manage access to all connec...

We are happy to announce that we have just released the February update for the On-premises data gateway (version  3000.114.6 ) Download on-premises data gateway (Standard mode) Download on-premises data gateway (personal mode) Compatible with February PBI Desktop  This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/run-time as in the February Power BI Desktop version. February updates Here are some of the things that we would like to highlight with this month’s release: All certified connectors can be used via the gateway Amazon OpenSearch Service (New Connector) OpenSearch Project (New Connector) Digital Construction Works Insights (New Connector) Azure Databricks (Connector Update) BQE Core (Connector Update) MicroStrategy (Connector Update) Starburst Enterprise (Connector Update)

We are happy to announce that we have just released the November update for the On-premises data gateway (version 3000.106.11 )     Compatible with November PBI Desktop  This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/run-time as in the November Power BI Desktop version.

We are happy to announce that we have just released the August update for the On-premises data gateway (version   3000.93.3 )     Compatible with August PBI Desktop  This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/run-time as in the August Power BI Desktop version.

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services. How the gateway works For more information on how the gateway works, see   On-premises data gateway architecture . Types of gateways There are three different types of gateways, each for a different scenario: On-premises data gateway : Allows multiple users to connect to multiple on-premises data sources. With a single gateway installation, you can use an on-premises data gateway with all supported services. This gateway is well-suited to complex scenarios in which multiple people access multiple data sources. On-premises data gat...