On-premises Knowledge Gateway (aka Energy BI Enterprise Gateway) is launch some time in the past (2 Dec. 2015), however, with the most recent launch on 22 Dec. 2015 Energy BI Enterprise Gateway now helps stay connections to each SQL Server Evaluation Providers Multidimensional and Tabular fashions in addition to SAP HANA. On this put up I’ll clarify a lot of essential elements of the Energy BI Enterprise Gateway together with set up,  configuration for various information sources together with SSAS Multidimensional, Tabular and SQL Server Database and way more. If that you must have the bottom potential latency then you definitely want DirectQuery/Discover Dwell characteristic on high of your on-premises information sources. The excellent news is that Energy BI Enterprise Gateway now helps all following information sources:

• SQL Server Database
• SQL Server Evaluation Providers Multidimensional
• SQL Server Evaluation Providers Tabular
• SAP HANA

  On this article you’ll discover ways to set up and configure Energy BI Enterprise Gate Manner, the right way to handle totally different stay information sources, the right way to create experiences on high of stay information sources and extra.

• Notice 1: If you wish to use DirectQuery to connect with your on-prem SQL Server Database OR Discover Dwell your SQL Server Evaluation Providers Tabular mannequin then you definitely may not want to put in and use the Energy BI Enterprise Gateway. In these instances you possibly can set up Energy BI Private Gateway to connect with an occasion of SQL Server OR set up Energy BI Evaluation Providers Connector to connect with your on-prem occasion of SQL Server Evaluation Providers Tabular mannequin slightly than putting in the Energy BI Enterprise Gateway. However, keep in mind that selecting the right gateway is de facto relying in your use instances, your information sources and the surroundings you’re engaged on.

• Notice 2: The Energy BI Enterprise Gateway and Energy BI Private Gateway CAN be put in on the identical machine.

  You may obtain the gateway from Energy BI web site once you logged in to your account and click on on “Energy BI Gateways” from the obtain menu:

  

  OR you possibly can go straight to the gateway web page then obtain the Energy BI Gateway – Enterprise (Preview):

  

Managing Knowledge Supply Customers

Managing information supply customers is identical for SQL Server Database, SQL Server Evaluation Providers Multidimensional (SSAS Multidimensional) and SQL Server Evaluation Providers Tabular (SSAS Tabular). The customers you add will be capable of publish experiences that use the info sources. So it’s trivial that the customers ought to have learn entry to the databases (SQL database, SSAS cubes or SSAS tabular fashions).

• Fro the Gateways web page develop the gateway to see the underlying information sources
• Click on a desired information supply
• Click on “Customers” tab
• Enter the customers’ e-mail addresses then click on Add (you possibly can add a couple of customers on the similar time)

Notice: Join stay to SSAS is now launched and it isn’t in preview anymore. So some components of this part is perhaps out-dated. You could find extra about Join Dwell to SSAS Multidimensional right here.

Beforehand we weren’t in a position to join on to an occasion of SSAS Multidimensional. However, utilizing the brand new Energy BI Enterprise Gateway we are able to browse the cubes instantly from Energy BI Desktop. On this sanction I present you the right way to do the job.

• Open Energy BI Desktop. The Energy BI Desktop must be put in on a machine which is in the identical community as you put in the Energy BI Enterprise Gateway.
• Click on “Choices” from File-> “Choices and Settings”

• Click on “Preview Options” then tick “Discover stay with SQL Server Evaluation Providers multidimensional fashions” then click on OK

• You’ll get the beneath message, click on OK, then shut the Energy BI Desktop

• Open Energy BI Desktop once more
• Choose “Evaluation Providers” from Get Knowledge

• Enter the “Server” and “Database” names as you beforehand used within the Energy BI Enterprise Gateway configuration
• Ensure that “Discover stay” is chosen
• Click on OK

• Choose a dice then click on OK

• Voila… We’ve all dimensions and measure teams on the “Fields” pane

• Broaden “Web Gross sales”
• Tick “Web Gross sales Quantity” to create a brand new column chart
• Broaden “Gross sales Territory” dimension and tick “Gross sales Territory” hierarchy. (YES, hierarchies at the moment are supported in Energy BI Desktop)

• As you possibly can see the drill down motion is mechanically enabled on the column chart which suggests you possibly can simply drill all the way down to the decrease ranges of the chart. To take action merely click on the “Drill Down” button () to allow the drill down motion. Now you possibly can drill all the way down to the decrease ranges of the chart by clicking on every column:

• Click on “Publish” button from the ribbon to publish the report back to the Energy BI Service
• For those who get the register message then ensure you enter to the identical Energy BI account as you setup the Energy BI Enterprise Gateway

• You may click on the hyperlink to navigate to the report on the Energy BI Service

• For those who click on on the ellipsis button on the precise facet of the dataset you already printed you’ll see that the “This dataset connects to a SQL Server Evaluation Providers Tabular database & is all the time updated. You don’t must schedule a refresh on this dataset.” message.

Dwell connection to an occasion of SQL Server Evaluation Providers Tabular will not be a brand new characteristic. Beforehand we have been ready to connect with a stay dataset utilizing “Energy BI Evaluation Providers Connector”. The Evaluation Providers Connector is NOT suitable with the “Energy BI Private Gateway” so wanted to put in it on a separate machine. Whereas with the brand new “Energy BI Enterprise Gateway” now we have the power to stay connect with all supported information sources together with SSAS Multidimensional, SSAS Tabular and SQL Server database (and naturally SAP HANA which isn’t part of this text).

We at the moment are in a position to DirectQuery to a SQL Server Database from Energy BI Desktop on high of Energy BI Enterprise Gateway which suggests we don’t have to setup schedule refresh on the Energy BI Service (Energy BI web site) anymore. With DirectQuery characteristic our Energy BI experiences and dashboards will likely be all the time up-to-date because the dataset is utilizing a stay connection to  our SQL Server database.

• Open Energy BI Desktop
• Click on “SQL Server” from Get Knowledge

• Enter server identify
• Enter database identify (database identify is elective) and click on OK

• Click on “Join” (For those who’re utilizing home windows authentication then you definitely’re good to go, however, if you wish to use SQL Server authentication then that you must click on Database and enter your SQL credentials)

• Choose DimDate and FactInternetSales from the checklist then click on “Load”

• Broaden FactInternetSales and tick SalesAmount
• Broaden DimDate and tick CalendarYear

• Click on “Publish” button from the ribbon to publish the report into the Energy BI Service

• Click on on the hyperlink to navigate to the report from the Energy BI Service