Friday, September 11, 2015

Power BI using data from a OData Web Service

RESTful Services are much better 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:
or AdventureWorks here

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:


 For details of how to create a report from scratch review this post.

No comments: Protection Status