Forum Discussion
Access data from C-tree database?
Anonymous,
You can create ODBC DSN for your C-tree database with the help of Faircom driver. Then connect to the ODBC data source using ODBC connector in Power BI Desktop, create report in Desktop and publish report to Power BI Service.
In Power BI Service, you can create dashboard for your report.
Regards,Lydia
Anonymous,
Dashboard only exists in Power BI Service. It is not possible to directly connect to ODBC data source in Power BI Service.
In addition, you can create ODBC dsn in the Power BI Desktop machine, and then use the ODBC connector in Power BI Desktop to connect to the dsn. Just make sure that you are able to access the remote database when creating ODBC dsn in the Desktop machine.
Regards,
Lydia
Anonymous,
You can create ODBC DSN for your C-tree database with the help of Faircom driver. Then connect to the ODBC data source using ODBC connector in Power BI Desktop, create report in Desktop and publish report to Power BI Service.
In Power BI Service, you can create dashboard for your report.
Regards,
Lydia
Thank you Lydia. I have two followup questions
1. Can't I create the dashboard in Power BI dashboard itself? Should I have to create the dashboard only in Power BI Service?
2. I have to access this server which stores this database remotely. Is it still possible to use the OBDC connector if the server has to be accessed remotely?
Regards,
Ruban
Anonymous,
Dashboard only exists in Power BI Service. It is not possible to directly connect to ODBC data source in Power BI Service.
In addition, you can create ODBC dsn in the Power BI Desktop machine, and then use the ODBC connector in Power BI Desktop to connect to the dsn. Just make sure that you are able to access the remote database when creating ODBC dsn in the Desktop machine.
Regards,
Lydia