Before you connect your report application to Sybase Database, you must make sure that ODBC data source of SQL anywhere connection is connected to sybase database successfully. If you don't have one, see how to create it here.
Assume that the odbc connection is connected successfully.
Everything is ready now. It's time to connect powerbi to data source. Follow three steps to connect powerbi to the data source:
- Choose Data Source connection type
- Choose data source name(DSN) and configuration
- Select database component to load into report application.
Choose Data Source Connection type
In microsoft powerbi desktop, click on Get Data in Home Tab and then choose More...
Click on Other on the left panel and click on ODBC on the right panel.
Choose Data Source Name(DSN) and Configuration
When From ODBC dialog is appeared, choose Data Source Name(DSN) and then click OK button.
In Access a data source using an ODBC driver dialog, Click on Database on the left panel and type user name and password for accessing to the database.
Select database component to load into report application
In Navigator dialog, check on tables or views or stored procedure to load into report application and then click on Load button.
Now you get data into your report application.
Hope this post is helpful for you :) .
