Forum Discussion
Integration of custom service
IoT-Guy,
Firstly, which backend database do you use for the AWS service? In Power BI Desktop, you can import data from different kinds of database servers(SQL Server , Oracle, MySQL, DB2, etc.). And you are able to connect to multiple data sources in a single PBIX file. You don't have to use Rest API in this case.
Secondly, it is possible to create an ODBC datas source for hadoop cluster, and then connect to the ODBC data source in Power BI Desktop, there is a blog for your reference.
Thirdly, in Power BI Desktop, you are able to develop your own custom connector.
Regards,
Lydia
IoT-Guy,
Firstly, which backend database do you use for the AWS service? In Power BI Desktop, you can import data from different kinds of database servers(SQL Server , Oracle, MySQL, DB2, etc.). And you are able to connect to multiple data sources in a single PBIX file. You don't have to use Rest API in this case.
Secondly, it is possible to create an ODBC datas source for hadoop cluster, and then connect to the ODBC data source in Power BI Desktop, there is a blog for your reference.
Thirdly, in Power BI Desktop, you are able to develop your own custom connector.
Regards,
Lydia
Hello Lydia,
thanks for your answer.
We are storing our data in a hadoop cluster (structured data) and as well in S3 (unstructured data). It's good to know, that I can connect multiple data sources. Your answer helped a lot.
Best,
Michael