Energy BI Enterprise Gateway (Preview), Episode 1

On-premises Information 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 reside connections to each SQL Server Evaluation Providers Multidimensional and Tabular fashions in addition to SAP HANA. On this publish I’ll clarify a lot of vital points of the Energy BI Enterprise Gateway together with set up, configuration for various knowledge sources together with SSAS Multidimensional, Tabular and SQL Server Database and way more. If you have to have the bottom doable latency then you definately want DirectQuery/Discover Stay characteristic on high of your on-premises knowledge sources. The excellent news is that Energy BI Enterprise Gateway now helps all following knowledge 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 Means, the right way to handle completely different reside knowledge sources, the right way to create stories on high of reside knowledge sources and extra.
Observe 1: If you wish to use DirectQuery to connect with your on-prem SQL Server Database OR Discover Stay your SQL Server Evaluation Providers Tabular mannequin then you definately won’t 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 quite than putting in the Energy BI Enterprise Gateway. However, keep in mind that choosing the right gateway is admittedly relying in your use instances, your knowledge sources and the surroundings you’re engaged on.
Observe 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 Information Supply Customers

Managing knowledge 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 have the ability to publish stories 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 increase the gateway to see the underlying knowledge sources
Click on a desired knowledge 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)

Observe: Join reside to SSAS is now launched and it isn’t in preview anymore. So some components of this part could be out-dated. You will discover extra about Join Stay 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 will browse the cubes immediately 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 needs to 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 reside with SQL Server Evaluation Providers multidimensional fashions” then click on OK

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

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

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

Choose a dice then click on OK

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

Increase “Web Gross sales”
Tick “Web Gross sales Quantity” to create a brand new column chart
Increase “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 robotically enabled on the column chart which implies you possibly can simply drill right 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 right 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
In case you get the sign up message then be sure 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

In case you click on on the ellipsis button on the best aspect of the dataset you already revealed 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.

Stay connection to an occasion of SQL Server Evaluation Providers Tabular isn’t a brand new characteristic. Beforehand we had been ready to connect with a reside 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 flexibility to reside hook up with all supported knowledge 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 implies we don’t must setup schedule refresh on the Energy BI Service (Energy BI web site) anymore. With DirectQuery characteristic our Energy BI stories and dashboards will probably be all the time up-to-date because the dataset is utilizing a reside connection to our SQL Server database.

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

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

Click on “Join” (In case you’re utilizing home windows authentication then you definately’re good to go, however, if you wish to use SQL Server authentication then you have to click on Database and enter your SQL credentials)