Power BI Preview–Getting the Data
Posted by denglishbi on April 1, 2015
In the first two posts we looked at Getting Started with Power BI Preview and then Power BI Preview Layout Overview. The next item that you will want to do now that you are somewhat familiar with the “new” Power BI is getting data to create datasets, reports, and dashboards!
Power BI Preview is known as a SaaS (software as a service) – a web-based service that you can leverage to deliver your solutions. As mentioned in the first post there is a free as well as subscription based offering ($9.99 per user/month) . There are also canned built-in solutions that you can leverage right out-of-the-box. So if you are using or have any of the following services or functionality the time it will take for you to getting insights is greatly reduced, you can get a kick start to your reporting with just a few clicks:
– Excel workbooks: leverage existing Excel files; could contain tables, charts, data models, Power View reports; these would be uploaded to the Power BI Preview site
– Power BI Designer File: we will cover this more in the next post, but if you download the designer and then load data, create reports, and save the file you can upload this into the Power BI Preview site
– SQL Server Analysis Services: with the downloadable connector that was mentioned in the second post for the layout overview you have the ability to query on-premise tabular SSAS databases
– Online services: if you are using GitHub, Marketo, Microsoft Dynamics CRM, Salesforce, SendGrid, or Zendesk you can connect using your credentials and there are pre-built templates that will be created for you with dashboard, reports, and dataset to jump start and get quick insights to the service and your usage
– Retail Analysis Sample: the initial sample that gets displayed and you see in the first two posts; sample file you can get familiar with to see functionality and test drive
To get started simply click on the Get Data (item #2 in the Layout Overview post).
Now you will see the list of the options you have to get started to work with data.
As an example let’s take a look at the GitHub option we will go to GitHub –> Connect.
You will then be prompted for authorization and I am already signed into GitHub. This is using oAuth.
This will now create a new dataset, reports, and dashboard. It will connect and begin to import the data that will populate the dashboard and you will be able to immediately get some insights!
And if you look at the reports that were added you can see there is additional information that you can review and add to the dashboard and you can also create more reports and enhance the out-of-the-box template that was provided.
Pretty amazing, and this is all free!
In the next post we will take a look at using the Power BI Designer to create our own dataset and reports that we can then use to load into the Power BI web site.