LogoLogo
API Documentation
Current Version
Current Version
  • DecisionRules Documentation
  • DecisionRules Academy
  • API
    • API Introduction
    • API Keys
      • Solver API Keys
      • Management API keys
      • BI API keys
    • Rule Solver API
    • Management API
      • Rule Migration Strategies
      • Deprecated Endpoints
    • Console Logs API
    • Business Intelligence API
      • Deprecated Endpoints
    • Datacenters & Locations
      • Global Cloud
      • Regional Cloud
    • Apache Kafka Solver API
    • Endpoint Settings
    • Archive
      • Rule Flow Solver API (DEPRECATED)
  • AI Assistant
    • About Assistant
    • Assistant Setup
      • Gemini Assistant
  • RULES
    • Rules Introduction
    • Rule List
    • Rule Mode
    • Common Rule Features
      • Input & Output Model
        • Simple Editor
        • JSON Editor
      • Test Bench
      • Rule Alias
      • Rule State
      • Versioning
      • Rule Variables
      • Execution Strategy
      • Rule Dependencies
      • Rule Export & Import
        • Rule Export
        • Rule Import
        • Managing Decision Table in Excel/Google Sheets
        • Deprecated Formats: XLSX v.1 and CSV
      • Tags
      • Rule Comparison
        • Decision Table Comparison
        • Decision Tree Comparison
        • Scripting Rule Comparison
      • Rule Lock
      • Teamwork Indicator
      • Event Timeline
    • Data Types & Functions
      • Supported Data Types
      • Operators and Functions
        • Basic operators
        • Date operators
        • Functions
          • Logical Functions
          • Math Functions
          • Date and Time Functions
          • Text Functions
          • Data Functions
          • Array Functions
          • Integration functions
          • Functions and JSON
    • Decision Table
      • Table Designer
        • Table Operations
          • Filter Values
          • Valid Values
          • Sorting
      • Binding to Model
    • Decision Tree
      • Tree Designer
    • Workflow
      • Workflow Designer
      • Workflow Nodes Overview
      • Workflow Limits
    • Scripting Rule
      • Custom functions in Scripting Rules
      • Calling external API within ScriptingRules
      • Use Rule Variables in Scripting Rules
      • Call Embedded Rules in Scripting Rules
      • Tips
    • Rule Flow
      • Rule Flow Designer
      • Rule Flow Mapping
      • Rule States in Rule Flow
      • Warnings & Errors
      • Rule Flow Limits
  • SPACE
    • Space Introduction
    • Space Info
    • Dashboard
    • Access
    • API Keys
    • Audit Logs
  • Organization
    • Organization Introduction
    • Organization List
    • Members
    • Teams
    • Spaces
    • Space Roles
    • Policies
    • Statistics
    • Settings
  • Profile
    • Profile Introduction
    • General
    • Dashboard
    • Plans
    • Add-ons
    • Limits
      • Plan Limits Explained
    • Subscriptions
    • Invoices
  • Access
    • Sign Up & Login
    • Invitations & Permissions
    • Single Sign-On (SSO)
  • Business Intelligence
    • Audit Logs
    • Power BI Connectivity
      • Create a Power BI Report
      • Connect Power BI to Business Intelligence API
      • Connecting from Power BI (deprecated)
      • Connect DecisionRules to Power BI Using Our Custom Connector
  • OTHER DEPLOYMENT OPTIONS
    • Regional Cloud
      • Region Specific API URLs
    • Docker & On-Premise
      • Environment Variables
      • Redis Connection Modes
      • DecisionRules Application
        • Minimal Requirements
        • DecisionRules Server
        • DecisionRules Client
        • DecisionRules Business Intelligence
        • Networking Between Docker Containers
      • Setup Single Sign-On (SSO)
        • Set up Microsoft Entra ID SSO
        • Set up Google SSO
      • Docker Showcase App
        • Showcase
        • Showcase + Business Intelligence
      • AWS Setup
        • AWS ECS/Fargate
        • Cache - Amazon ElastiCache
      • Microsoft Azure Setup
        • Database - Azure CosmosDB
        • Cache - Azure Cache for Redis
        • Azure Container Apps
      • Azure Red Hat OpenShift
      • Google Kubernetes Engine (GKE)
      • Kubernetes Setup
        • Kubernetes Setup with Business Intelligence
      • Logging options
      • CD/CI Pipelines
        • Azure DevOps CICD Pipelines
        • Using Migration script (old way)
      • Offline License
      • White Labeling
  • SDK and Integrations
    • Languages / Frameworks
      • SQL Server
      • Oracle PL/SQL
      • PostgreSQL
      • JavaScript
      • Java Spring Example
      • PHP Library
      • Python Library
      • .NET Library
      • Google Tag Manager
    • Excel Add-in
  • Terms & Conditions
    • Terms and Conditions
    • Privacy Policy
    • Service Level Agreement
      • Community Support
      • Standard Cloud (SaaS)
      • Silver SLA
      • Gold SLA
      • Custom SLA
    • Sub-Processor List
  • Product Updates
    • Release Notes
      • Public Cloud
      • On-Premise / Private Cloud
    • Major Updates
      • Changes in Version 1.19.0 (10/2024)
      • Changes in Version 1.20.0 (4/2025)
    • Roadmap
Powered by GitBook
On this page
  • How to Connect PowerBI and DecisionRules
  • Step 1 - MongoDB
  • Step 2 - BI Connector
  • Step 3 - ODBC Driver
  • Step 4 - Power BI Connection

Was this helpful?

  1. Business Intelligence
  2. Power BI Connectivity

Connecting from Power BI (deprecated)

This tutorial describes how to connect DecisionRules data stored in your own (on-premise) MongoDB database from Power BI to visualize or analyze it.

Last updated 10 months ago

Was this helpful?

This way of loading rule solver data to Power BI is no longer recommended. We have provided the which can be used to achieve the same goal in a much easier way. Check out the tutorial.

How to Connect PowerBI and DecisionRules

To aproach DecisionRules data (Rule Engine statistics, Rule Input/Output data etc.) seated in MongoDB database we recomend to use/setup BI Connector and MongoDB ODBC Driver for BI Connector.

The MongoDB ODBC Driver for BI Connector provides connectivity between a SQL client and the MongoDB Connector for BI. The ODBC driver enables users to create a Data Source Name (DSN) and connect a variety of BI tools to the BI Connector. It includes the BI Connector authentication plugin, which implements the client side of MongoDB-supported authentication mechanisms.

Step 1 - MongoDB

In section Security - Database Access create new User, e.g. "dbReportUser" with Role "readAnyDatabase".

In section Security - Network Access also setup IP address of host that will aproach your MongoDB database (value 0.0.0.0/0 means Any host).

Step 2 - BI Connector

The MongoDB Connector for BI allows you to use your BI tool of choice to visualize, discover, and report against MongoDB data using standard SQL queries. There are two options how to put it between ODBC Driver and MongoDB:

A) MongoDB BI Connector running in Cloud

If you run your DecisionRules on MongoDB Atlas (MongoDB Cloud Services), just edit configuration of MongoDB database (in Additional Settings - Advanced Settings) and switch on the option "Enable Business Inteligence Connector".

Then choose option Connect - Connect Business Intelligence Tool and see the essential parameters for MongoDB ODBC Driver.

B) MongoDB BI Connector running localy

Run the downloaded .msi file and follow the wizard instructions to install the files. The binaries install into a bin directory (e.g. C:\Program Files\MongoDB\Connector for BI\2.14\bin) inside the installation directory. You can delete the old binaries.

To start BI Connector localy with necessary parameters for connecting DecisionRules MongoDB use following example of configuration file:

Inside this file you have to edit variable "mongodb: net: uri" by string you will find in your MongoDB, where you have tu choose option Connect - Connect your application and select DRIVER "Node.js" and its VERSION "2.2.12 or later". The underlined text (see picture bellow) "mongodb://.....27017" is the value you have to writedown into the variable "mongodb: net: uri" (in the file "mongosqld-config-for-DecisionRules.yml" file). Do not forget to edit also variable "username" and "password" that you have created in Step 1.

Last very important variable in "mongosqld-config-for-DecisionRules.yml" file is "schema: path". For DecisionRules MongoDB you can use following template of database objects definition:

You are now ready to launch the BI Connector, but remember, if your MongoDB instance uses authentication, your BI Connector instance must also use authentication. The user that connects to MongoDB via the mongosqld program must have permission to read from all the namespaces you wish to sample data from.

In Command Prompt go to the directory where the BI Connector has been installed (and where you put also the "mongosqld-config-for-DecisionRules.yml" and "schemaDecisionRules.drdl" files) and write "mongosqld --config mongosqld-config-for-DecisionRules.yml" and press Enter. You should see something like this:

Step 3 - ODBC Driver

Download and install the suitable ODBC Driver for MongoDB from:

Start the Microsoft ODBC Data Sources program (choose the program version, 64-bit or 32-bit, which is appropriate for your system and ODBC driver version), select System DSN, then click Add and choose the MongoDB ODBC ... Unicode Driver from the list of available drivers. Click OK.

The following ODBC parameters are required:

  • Data Source Name: A name of your choice

  • TCP/IP Server: The Hostname specified in the MongoDB Connect BI Tool dialog (MongoDB BI Connector running in Cloud) or IP address (bindIp variable) defined in momgosqld configuration file (MongoDB BI Connector running localy)

  • Port: The Port number specified in the MongoDB Connect BI Tool dialog (in MongoDB BI Connector running in Cloud the default is 27015, in MongoDB BI Connector running localy it is defined by variable port in n momgosqld configuration file)

  • Database: The name of the DecisionRules database (the default is Decision)

  • User: Enter either the user specified in the MongoDB Connect BI Tool dialog (in our example it is dbReportUser). The user is specified in the following format: Username?source=AuthDB where AuthDB is the authentication database for the user: - If AuthDB=admin you can omit "?source=admin" string - If you are using Username and Password (SCRAM-SHA-1) authentication, the expected authenticating database is "admin" - If you are using LDAP (PLAIN) authentication, the expected authenticating database is "$external" (EXAMPLE: myTestUser?source=$external)

  • Password: The password that corresponds to the specified User (in our example it is dbReportUser).

Click Test to validate the ODBC connection. If the connection is successful, click OK to add the DSN. If the connection fails, check to make sure your database user is correctly authenticated for the database named in the connection.

Step 4 - Power BI Connection

I you named your System DSN "DecisionRules_MongoDB" or "MongoDB_via_localBIconnector" (as mentioned above) you can immediately use our Power BI Template Files - see bellow:

Just download one of these files (depending of your BI Connector solution) and open it. If you will see following Warning: There are pending changes in your queries that haven't been applied. Choose "Apply Changes".

In the Model section you should see the following tables and their relationships:

In the Report section you should see the prepared visualizations like "Dashboard", "API Calls per Time", "API Calls per Rule" or report of particular rule called "Client Profitability 2" (in this case of reporting a specific rule you will not see any data, this report and its data source are in template only for your inspiration how you can connect and visualize data about a particular rule). See bellow several expamples from the eppTec Power BI Template File:

We prefer to run the MongoDB BI Connector localy (it means on your local server/PC). It does not matter if your DecisionRules MongoDB is installed in your Cloud or on your local server, you have to first download and install (Prerequisite: has been installed on your host) the suitable BI Connector for MongoDB from:

To help you get started MongoDB BI Connector (mongosqld.exe file), a sample of named example-mongosqld-config.yml is included with the installation package. To learn how to start BI Connector with a configuration file, refer to the mongosqld documentation section on the .

Visual C++ Redistributable for Visual Studio 2015
configuration file
Configuration File
Business Intelligence API
Connect Power BI to BI API
851B
mongosqld-config-for-DecisionRules.yml
6KB
schemaDecisionRules.drdl
1MB
eppTec_RuleEngine_Reports_BIconn_running_in_Cloud.pbix
1MB
eppTec_RuleEngine_Reports_BIconn_running_localy.pbix
Using MongoDB BI Connector running in Cloud
Using MongoDB BI Connector running localy
Dashboard overall
Dashboard for particular User
All API Calls in particulat Time Period
The most called Rules
Example of reporting output values for a particular Rule
Example of reporting dependencies between output and input values for a particular Rule
MongoDB BI Connector DownloadMongoDB
Logo
Releases · mongodb/mongo-bi-connector-odbc-driverGitHub
Logo