Trying to connect to MongoDB using MongoDB ODBC driver

Try following steps:

I used Advanced Options and wrote SQL Statement (select * from zips) to resolve but this is not concrete solutions but still you can work.

1. In Power BI Desktop, click Get Data.

1. In the Get Data dialog box, click other, then select ODBC from the list of data source types, and then click Connect.

1. In the From ODBC dialog box, in the Data Source Name (DSN) drop-down list, select your DSN.

1. Optionally, to specify what data is returned with a SQL statement, expand the Advanced Options area and then, in the SQL Statement (Optional) field, type or paste a SQL statement to specify the data.

1. Click OK. If you are prompted to provide your credentials, then do one of the following:

• If your data store requires credentials for access, then in the Username and Password fields, type your credentials for accessing your data store, and then click Connect.

• Otherwise, from the column on the left, select Default or Custom and then click Connect.

A dialog box opens and displays the data that is returned from the data store. If you used a SQL statement to specify what data is returned, then the dialog box only displays the rows returned by the SQL statement.

1. Choose one:

• If you did not use a SQL statement to select your data, then select the check boxes next to the tables that you want to import and click Load.

• Or, if you used a SQL statement to select your data, click Load.

The selected data is loaded into Power BI Desktop and listed in the Fields task pane. You can now use Power BI to analyze the data.

Thanks,

Rizwan Siddiqui