Connection problem mentioned in the previous post:
PowerBI Preview reporting from SQL Anywhere 16 - Part 1
was resolved.
This post describes the correct way of making a connection to SQL Anywhere 16 from Power BI and generating a report from a View on the server.
If this is the first time you land on this page, please review the following post that describes the step-by-step process:
http://hodentekmsss.blogspot.com/2015/02/authoring-report-with-power-bi-using.html
Make sure the SQL Anywhere 16 network server has started. After launching PowerBI and hitting the Get Data link the following screen will be displayed:
sybase3
Click connect to connect to the SQL Anywhere 16 server running on your laptop. The following screen is displayed.
Sybase17
Enter Server and Database name as shown. You can read this from the server startup screen superimposed.
Click OK on this screen. The following screen is displayed. If instead of this you may get an authentication window. In which case choose 'Database' login and use the sql/dba pair for authentication.
Sybase18
You may recognize these as the tables on the 'Demo' database on the samples provided by Sybase (SAP).
By default only the tables are displayed. In order to display views you may have to search for them. Review this screen from Sybase Central connected to the same server.
Sybase19
There is a View called ViewSalesOrders. Insert this in the search box and click search. The ViewSearchOrders data will be displayed as shown.
Sybase20
Clock Load and load the data to the BI Designer. Perhaps this data may not be the greatest data ti mine, but let us go ahead and see. The data gets loaded to the mode as shown.
As shown in my previous post choose the items to be included in your report as shown on the right extreme of the next image which shows all the fields contained in the View. The report gets generated in no time at all. All that was done was to choose the fields. it cannot get any dumber!
PowerBI Preview reporting from SQL Anywhere 16 - Part 1
was resolved.
This post describes the correct way of making a connection to SQL Anywhere 16 from Power BI and generating a report from a View on the server.
If this is the first time you land on this page, please review the following post that describes the step-by-step process:
http://hodentekmsss.blogspot.com/2015/02/authoring-report-with-power-bi-using.html
Make sure the SQL Anywhere 16 network server has started. After launching PowerBI and hitting the Get Data link the following screen will be displayed:
sybase3
Click connect to connect to the SQL Anywhere 16 server running on your laptop. The following screen is displayed.
Sybase17
Enter Server and Database name as shown. You can read this from the server startup screen superimposed.
Click OK on this screen. The following screen is displayed. If instead of this you may get an authentication window. In which case choose 'Database' login and use the sql/dba pair for authentication.
Sybase18
You may recognize these as the tables on the 'Demo' database on the samples provided by Sybase (SAP).
By default only the tables are displayed. In order to display views you may have to search for them. Review this screen from Sybase Central connected to the same server.
There is a View called ViewSalesOrders. Insert this in the search box and click search. The ViewSearchOrders data will be displayed as shown.
Clock Load and load the data to the BI Designer. Perhaps this data may not be the greatest data ti mine, but let us go ahead and see. The data gets loaded to the mode as shown.
As shown in my previous post choose the items to be included in your report as shown on the right extreme of the next image which shows all the fields contained in the View. The report gets generated in no time at all. All that was done was to choose the fields. it cannot get any dumber!
Sybase21
That is all folks! Namaste
No comments:
Post a Comment