How to set up a data source ODBC on Power BI Service

[Zhanna2222]

Hi Everyone,

My data source is locating in MongoDB. I have successfully managed to used the ODBC connector in Power BI Desktop.

I would like to create a data source on Power BI Service to get data from MongoDB via ODBC connector.

Is it possible to connect MongoDB to Power BI Service via ODBC connector ? 

How can I create a data source for ODBC on Power BI Service?

Thanks in advance for your help.

Kind regards

Zhanna

[v-xiaotang]

Hi @Zhanna2222 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau · Accepted solution]

Hi. You need a Data Gateway in a vm at the same network of your mongoDB.

You can read more about gateway here: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

The VM with the Gateway installed should also install the ODBC and work as a bridge between PowerBi Service and your MongoDB

I hope that helps,