Friday, September 11, 2015

Visualizing Data using Power BI from RESTful Web Services

RESTful Services are much simpler than SOAP based services using WSDL. SQL Server Database can be exposed as a resource through a RESTful service and using RESTful API you can get data formatted in a standard way for different kinds of applications.

Some of the database examples that can be used for working with RESTful web services may be found here:

Northwind Service:
AdventureWorks Service: and AdventureWorks OData Service here,, or

You can easily connect to OData data feed from the above services using PowerBI as detailed here:
Once you are connected you can easily visualize data which is Page1 of the visualization as shown here:

Publishing the report:
You Publish this report to site. Before publishing you may have to Save the changes you have made.


In order to publish you need a Power BI account.


For Microsoft Data Management Gateway read here:

Creating data visualization
The following describes a step-by-step procedure to create a visualization report such as the one you saw earlier.

Step 1: Click New Page in the ribbon to add a new page to your report.
The new page becomes Page 1 while the previous becomes Page 2

Step 2: Click ProductName under Fields. The ProductName Column gets added to the Page as shown. In Visualizations, ProductName (all) is added.


Under Visualizations click on ProductName (all) under Visual Level Filters. This opens up all the product names as shown.


You can filter the product name by choosing a couple of them (or as many as required for your report) as shown (here a dozen or so chosen).


Step 3:

Click Order_Details under Fields and choose Quantity and Price (by placing check marks) as shown. These gets added to the visualization page.


Step 4: Click on Clustered Column chart and the chart is created in the page as shown.


Step 5: You can make changes to the chart by clicking on the Format icon right next to chart.


Step6: For example you can make changes to the chart title by expanding the configurable items of the Title as shown.


In Page 2 all the products were chosen and there was a vertical scrollbar to review a product and in the present page only few are chosen.

It is very easy to create visualizations and modify them quite easily.

Step 7: Click on Multi-row card under visualizations and the page visualization changes accordingly as shown.


PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...