Welcome back everyone. In the 1st part of this series I showed you how to configure and deploy the built-in SSAS cubes that come packaged with Microsoft Dynamics. We pick back up with what I like to consider the meat of this data stew. Now we connect our cubes with Power BI to allow the consumption of that data.
Lets begin by installing the On-Premises data gateway. You may read more about the full details of the gateway by clicking here. With our gateway downloaded lets begin the install.
You can learn the full details about the variations of the gateways by clicking on the learn more links under each. Continuing on with our install select the first option and click next.
Ideally this would be most likely installed on the same SQL server as your cubes but that doesn’t have to be the case, for the ease of this demo we will be installing the gateway on our SQL server.
Once the install is complete you will be prompted to enter your PowerBI credentials. Then click Sign In.
Once your credentials are entered in the next step is to provide a name for your gateway as well as a recovery key. It is important to remember this information so you will want to right it down in a safe place.
Click on close. Then we may proceed onto the rest of the configuration via the PowerBI.com web site.
Once you are logged into PowerBI you will click on the sprocket at the right of the corner and select the option to manage gateways.
You will then be brought to a screen that looks like this.
Now we want to add our data source for the cubes we have deployed. When you click on the … to the right of your gateway name you will see the option to add a data source.
You will give the data source a name and the next option is to select a data source type. In our case we will select Analysis Services.
The next come the details of the SSAS cube.
Once you have the details entered in click on Add.
This brings us to the final steps to get access to our data. Click on the users tab and at the bottom of the screen on the right hand side click the option for Map user names.
You will want to read all the information in this link here about mapping users to get a full detailed run down on this. The simple run down of this window is we’re mapping our PowerBI account with that of our local account we supplied when creating the data source. This allows the security to map between your on premise data and the PowerBI service.
That wraps up the 2nd part of our series. In the 3rd part of it which will be released out later in the week we will create a simple dashboard with our SSAS data and PowerBI.