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:
http://hodentekmsss.blogspot.com/2015/08/managing-relationships-in-power-bi.html
Once you are connected you can easily visualize data which is Page1 of the visualization as shown here:
V_Odata01.png
For details of how to create a report from scratch review this post.
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:
http://hodentekmsss.blogspot.com/2015/08/managing-relationships-in-power-bi.html
Once you are connected you can easily visualize data which is Page1 of the visualization as shown here:
V_Odata01.png
For details of how to create a report from scratch review this post.
No comments:
Post a Comment