Microsoft released a preview of PowerBI, an authoring tool for visualizing data from a variety of databases as described here:
I am a Sybase enthusiast and I tested whether or not it can connect to SQL Anywhere 16(being one of the Sybase Databases). However I come up with two different kinds of errors connecting to SQL Anyhwere 16
I have started the demo16 successfully. Now I provide the server name required by PowerBI as demo16 and the database name as demo. It throws an exception as follows:
DataSource.Error: Sybase SQL Anywhere: Connection error: No IP address found for demo16 Details: Message=Connection error: No IP address found for demo16 ErrorCode=-2147467259
I go back and look at the properties of the server and I find an IP Adress (NAT) of the computer on which I am running this server. If I use this information for connecting to server from PowerBI, i get a different error as follows:
DataSource.Error: Sybase SQL Anywhere: Login mode 'Integrated' not permitted by login_mode setting Details: Message=Login mode 'Integrated' not permitted by login_mode setting ErrorCode=-2147467259
Is the IPAddress of the demo16 server the same as the local machine? Is it possible to run the demo 16 server in Windows authentication mode?
Perhaps SQL Anywhere 16 is not supported?
The "'Integrated' not permitted" error is what you'll see if your connection string does not include UID or PWD. Can you post the entire connection string? Feel free to replace passwords with ***.
answered 11 Feb '15, 23:00
More details of the problem I faced are here with some screen shots: http://hodentek.blogspot.com/2015/02/powerbi-preview-reporting-from-sql.html
Finally found an answer that works
The server name should be : localhost:2638 the database name is: demo
For authentication use database authentication
answered 12 Feb '15, 16:34