Connect Data Stored in an InterSystems Product to Power BI

Connect InterSystems IRIS data to Power BI via the Health Insight Connector.

Updated Feb 2, 2026
One-click install
npx skills add https://github.com/sorodriguezz/skills-objectscript --skill connect-data-stored-in-an-intersystems-product-to-power-bi
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Connect Data Stored in an InterSystems Product to Power BI
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/connect-data-stored-power-bi
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill connect-data-stored-in-an-intersystems-product-to-power-bi

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables users to connect to and visualize data stored in InterSystems products within Microsoft Power BI, bridging the gap between operational data and business intelligence reporting.

Core Features & Use Cases

  • Connect to InterSystems IRIS: Utilize the InterSystems Health Insight Connector to establish a connection.
  • Browse Relational and Cube Data: Navigate and select tables, views, or BI cubes for reporting.
  • Publish Reports: Share Power BI reports and dashboards leveraging InterSystems data via the Power BI cloud service.
  • Troubleshooting: Provides solutions for common connection and data visibility issues.

Quick Start

Use the Connect Data Stored in an InterSystems Product to Power BI skill to connect to your InterSystems IRIS instance using its host, port, and namespace.

Frequently Asked Questions about Connect Data Stored in an InterSystems Product to Power BI

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect InterSystems IRIS data to Power BI for reporting?

You connect InterSystems IRIS data to Power BI by using the Health Insight Connector with your instance host, port, and namespace to browse and visualize relational tables and BI cubes.

Do I need an ODBC driver to visualize InterSystems data in Microsoft Power BI?

Yes, you must have the InterSystems IRIS ODBC driver installed and appropriate user credentials for authentication to successfully connect and visualize InterSystems data in Microsoft Power BI.

Can I use DirectQuery with InterSystems Business Intelligence cubes in Power BI?

Yes, the connection supports DirectQuery capabilities, allowing you to browse and analyze InterSystems Business Intelligence cubes and relational tables directly within Microsoft Power BI.

What is the best way to troubleshoot data visibility issues when connecting Power BI to InterSystems?

To troubleshoot data visibility issues when connecting Power BI to InterSystems, verify your ODBC driver installation, check user authentication credentials, and ensure the correct namespace is selected.

Does the InterSystems Health Insight Connector support publishing Power BI dashboards?

Yes, after establishing the connection, you can publish and share Power BI reports and dashboards leveraging your InterSystems data via the Microsoft Power BI cloud service.