Tag Archives: Power BI

Power BI Personal Gateway, Five Things You Must Know

When we are talking about using a new technology we need to understand it first. Power BI Personal Gateway is not an exception.  Despite you can easily install the Power BI Personal Gateway, knowing the following important points is crucial. I believe the following 5 points are significantly important to prevent you getting into troubles with the installation process as well as using the gateway:

image

  • Power BI Personal Gateway is only available on 64-bit Windows operating systems
  • Once you install Power BI Personal Gateway you don’t need to install another one as just one gateway works for any number of supported data sources
  • You CANNOT install the Power BI Management Gateway on the same machine as Power BI Analysis Services Gateway
  • If you’re trying to install the Power BI Personal Gateway on a network having Active Directory make sure that the account you’re using to install the Power BI Personal Gateway is able to “Logon as a Service”. In some cases the “Logon as a Service” policy is prevented on Active Directory for security reasons. The “Log on as a Service” should be applied to those accounts that are NOT under an Active Directory. So even if you are using a Local Account you should make sure that the local account is added to the local security policy “Log on as a Service”. If the account used to install the Power BI Personal Gateway is banned from the “Log on as a Service” policy you’ll get “Service ‘Data Management Gateway Service’ (DIAHostService) failed to start. Verify that you have sufficient privileges to start system services.” error message.

Continue reading Power BI Personal Gateway, Five Things You Must Know

Refreshing On-Prem SQL Server Database on Power BI using Power BI Personal Gateway

image It’s been awhile that lots of us were waiting for this feature. And some of us like me just tried to build it in our way. I spent some time to develop something similar using OData in combination with IIS and Basic Authentication features. Well, it was sort of successful and unsuccessful simultaneously! I mean, I was able to refresh SQL Server data remotely, but, when it came down to refreshing the dataset uploaded into the cloud Power BI it just failed. It was mainly because of the method that Power BI uses to refresh data.

By the way, I’m glad to see that we are finally able to refresh an on-premises SQL Server database from Power BI website. Refreshing data is very crucial for every report and dashboard which is working on top of frequently changing database.  So we need to be able to schedule a data refresh on the cloud. Yesterday Microsoft announced a new gateway specially designed for supporting data refresh for on-premises data sources as below:

  • SQL Server
  • Oracle
  • Teradata
  • IBM DB2
  • PostgreSQL
  • Sybase
  • MySQL
  • SharePoint List
  • SQL Analysis Services Tabular model (uploaded data, not live connections)
  • File (CSV, XML, Text, Excel, Access)
  • Folder
  • Custom SQL/Native SQ

As you see SQL Server is not the only one.

Installing Power BI Personal Gateway

It’s easy to install the Gateway. Just make sure that meet the following requirements:

  • The machine that you’re going to install the Gateway on it should be always up and running
  • You can NOT install the Gateway on the same machine as a Power BI Analysis Services Connector

image

Hold Your Dashboards in Your Pocket, Part 2: Use Your Predefined Dashboards on Your Windows Devices

In a previous post, “Hold Your Dashboards in Your Pocket, Part 1: Use Your Predefined Dashboards on Your IOS Devices“, I explained how to use Power BI app on your IOS devices.

In this post I express how to use Power BI app on your Windows devices. It’s relatively easy to install and use the Windows app.

  • Go to www.powerbi.com and click on the “Download from Windows Store” button


  • It automatically leads to the app page on your Windows Store
  • Click Install to install the app


  • After the app installed successfully open it from start menu

060215_0105_HoldYourDas3.png

  • Click Sign In


Continue reading Hold Your Dashboards in Your Pocket, Part 2: Use Your Predefined Dashboards on Your Windows Devices

Hold Your Dashboards in Your Pocket, Part 1: Use Your Predefined Dashboards on Your IOS Devices

Now it is time to take a step further and learn how to access our dashboards from our IOS or Windows devices. Microsoft designed a very good and handy app for IOS and Windows based tablets. At the moment the Windows app is only available for your laptop or on your Windows based tablet device. First of all you need to download the app on your device.

In this post I explain how to use your IOS devices to browse your dashboards everywhere that you have access to the Internet.

iPhone:

  • Sign-in into Microsoft Power BI website
  • From the right menu click on Download then click on “Power BI for IOS”

  • Click “Download on the App Store”

  • Select your IOS device and then click on “View in iTunes”

Continue reading Hold Your Dashboards in Your Pocket, Part 1: Use Your Predefined Dashboards on Your IOS Devices

Build your First Report in Microsoft Power BI Designer Part 2, Make it More User Friendly

PBID

In this post I would like to explain more details about Power BI Designer features. In the previous post you learnt how to create some very simple reports. However, those reports were just for testing general features of the tool. For instance we didn’t even play with very simple features like renaming the dimension or fact tables and members to user friendly names. In this article not only do I explain some of the simple ones, but also I’ll go through some of the more advanced ones.

Again, as per my previous post, I’m using AdventureWorksDW2012 as a source database.  We imported “Internet Sales” into the designer and we created some reports and one new page and we saved the reports on disc. So we have all the requirements on hand. Let’s go…

Making names more user friendly:

  • Open the *.pbix report file in Power BI Designer
  • Double click on “DimCurrency” to rename it to “Currency”. We need to do the same for all other objects

image

  • We also need to do the same for the fields which are getting used on the reports

image

Continue reading Build your First Report in Microsoft Power BI Designer Part 2, Make it More User Friendly

Build Your First Report in Microsoft Power BI Designer Part 1, Basics

image

First of all I would like to briefly explain Microsoft Power BI Designer. Then we’ll see how easy we can create a report using designer. I will use Adventure Works DW database as the source database.

Microsoft Power BI Designer is basically an integration of Power Query and Power View. Saying that the tool is still a preview version and it’s NOT actually a released product we’ll expect to see more features when it’s released. Some features like PowerPivot models expected to be available to the release version. At the moment PowerPivot models are not available in the designer, but, hopefully Microsoft will add it to the tool. So I added an idea into BI in SQL vNext as I believe it would be great to have PowerPivot functionalities included in the release version of the product. We’ll see what happens.

Let’s have a look at the tool. At the first look, I would like to say it’s an amazing tool integrating lots of awesome features all together with ease of use. It’s so fun to use the tool to create very effective and flashy reports in a short amount of time. First of all you need to download the designer from here.  Install the designer and open it. I’ll use AdventureWorksDW2012 as the source database.

Open the Microsoft Power BI Designer Preview. If you want to get more familiar with the tool click on the videos on the startup screen.

·         To connect to SQL Server click on “Get Data” or “New Source”

clip_image002

Continue reading Build Your First Report in Microsoft Power BI Designer Part 1, Basics