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:
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.

Retrieving Data on a SQL Anywhere Server Using AJAX

An AJAX call to an SQL Anywhere Server using stored procedures and web services

AJAX has dominated the web space so extensively that it needs no introduction. Connecting to a server via XMLHttpRequest and making a partial page refresh is what makes this technique so attractive. However, use of these AJAX requests, although very attractive, can pose dangers as well. JavaScript acts as a vector to infect websites with worms, such as SAMY, using cross-site scripting, also known as CSS or XSS.

In a previous article - "Enabling Server data with native web service" - I explain how a web service of type HTML is created on the SQL Anywhere server, which can serve HTML pages, and that to make an AJAX call for this page from your browser, you need to make a call to the hosting domain, the SQL Anywhere Web Server.

Read more at...
http://ajax.sys-con.com/node/646922

If you liked this article you may also want to read the one at.....
http://hodentek.blogspot.com/2008/07/soap-web-service-with-sql-anywhere.html

and the other related article at.....
http://hodentek.blogspot.com/2008/01/enabling-server-data-with-native-web.html

Soap Web Service with SQL Anywhere

Enabling interoperability is one of the greatest benefits of using web services. In the business world, applications work on different platforms with different operating systems running applications whose programming languages vary wildly. For applications to interact
with each other there should be a common method to transparently talk to all the different systems. In fact, the charter of the WS-I, an open industry organization source, is to promote this idea of interoperability across platforms, operating systems, and programming languages.

Read this article ...

Consuming a SQL Anywhere native web service using a .NET client
By Jayaram Krishnaswamy
International Sybase Users Group Technical Journal, May / June 2008, Pages 14 - 19

Join ISUG and get a load of benefits.