![mongodb bi tools mongodb bi tools](https://www.holistics.io/blog/content/images/2018/08/holistics----SQL-mongoDB-06.png)
#Mongodb bi tools download#
If you have not already done so, download the Power BI Gateway. Run the CData Power BI Connector installer.With the data source configured, follow the steps below to load data from MongoDB tables into your DataFlow.įollow the steps below to configure the gateway on your machine: Pulling MongoDB Data Directly Into Your Dataflow You can also execute free-form queries that are not tied to the schema. To access MongoDB collections as tables you can use automatic schema discovery or write your own schema definitions.
#Mongodb bi tools password#
Set the Server, Database, User, and Password connection properties to connect to MongoDB. You can use the Microsoft ODBC Data Source Administrator to create a new DSN or configure (and rename) an existing DSN: From the Start menu, enter "ODBC Data Sources." Ensure that you run the version of the ODBC Administrator that corresponds to the bitness of your Power BI Desktop installation (32-bit or 64-bit). Configure the DSN by filling in the required connection properties. This the name of the DSN that Power BI uses to request a connection to the data source.
![mongodb bi tools mongodb bi tools](https://res.cloudinary.com/hevo/image/upload/f_auto,q_auto/$wpsize_!medium_large!,w_768,h_434,c_scale/v1594221790/hevo-learn/MongoDB-to-Power-BI.png)
Installing the Power BI Connector creates a DSN (data source name) called CData Power BI MongoDB. Follow the steps below to pull data directly into DataFlows on and use the Power BI Gateway to configure automatic refresh. The CData Power BI Connector for MongoDB seamlessly integrates with the tools and wizards in Power BI, including the real-time data workflows on.