Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
IoT-Guy
New Member

Integration of custom service

Hello everyone,

 

I hope you can help to get a better understanding, how our solution could work.

 

We're would like to store a huge amount structured and unstructured data and make it accessible to MS PowerBI. Since we're starting from scratch I would like to consider also the requirements of MS PowerBI for this solution.

The data will be stored on AWS but we're not limited to the AWS services. Furthermore the structured and unstructured data is time-series data and it can be stored separatedly, if we can represented within one database model.

 

Since I found no information "How to integrate custom services or databases into MS PowerBI?" I not sure, what MS PowerBI expects. Are we fine with a hadoop cluster? Do we necesserily need a REST API etc.?

Can I implemented something like customer connectors in MS PowerBI to integrate my custom service?

What's the best way to make huge amount of data accessible for MS PowerBI also in terms of scaling?

 

I am properly not the first who wants to integrate a custom service into MS PowerBI, therefore it would be really great, if you could share some of your expierences.

 

Thanks in advance.

IoT-Guy

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors