topic Re: Is there any way to connect MongoDb / mysql server to power Bi cloud? in Report Server

Is there any way to connect MongoDb / mysql server to power Bi cloud?

Anonymous — Sat, 26 Nov 2022 07:12:19 GMT

Hello All

I'm trying to connect mongoDB to power BI cloud, I've found some solutions like

1. connect mongodb with powerBI desktop via OBCD, then publish to powerBI server.

2. using on premise gateway.

Both solution need my local pc intervention. So I need a work around how to connect MongoDB/MySql with powerBI server directly without local pc intervention.

Thanks a lot

Re: Is there any way to connect MongoDb / mysql server to power Bi cloud?

Shahfaisal — Sat, 26 Nov 2022 14:03:15 GMT

You will need to install the ODBC driver on one of the servers on the network and then use this ODBC driver in Power BI Desktop. After publishing, the report will continue to use the ODBC driver on the server so your PC is not going to be required.

See this on how to use MySQL as a data source - https://www.mssqltips.com/sqlservertip/2615/creating-a-ssrs-report-using-a-mysql-data-source/

Re: Is there any way to connect MongoDb / mysql server to power Bi cloud?

Anonymous — Tue, 29 Nov 2022 03:29:08 GMT

So, you mean I need to install ODBC on the server where my database (mysql/mongodb) is. Then I need to connect the ODBC in my desktop PowerBi at least for once? So, all I can say I can't get rid of power bi desktop

Re: Is there any way to connect MongoDb / mysql server to power Bi cloud?

Shahfaisal — Tue, 29 Nov 2022 07:02:54 GMT

Anonymous wrote:
So, you mean I need to install ODBC on the server where my database (mysql/mongodb) is. Then I need to connect the ODBC in my desktop PowerBi at least for once? So, all I can say I can't get rid of power bi desktop

No, you don't need to install the ODBC dirver on the same server as MySQL. Just install it on one of the servers on the network that can connect to the MySQL database. Then you setup the gateway - https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-odbc-support