The FaciliWorks Power BI Connector enhances your enterprise reporting capabilities by providing flexible, high-performance access to your organization’s data within Power BI. Key features include:
-
Organization-wide access: Connect to multiple FaciliWorks sites, not just a single application site.
-
Local or hosted installations: The connector works with both on-premises (local) and cloud-hosted FaciliWorks deployments.
-
Readable datasets: Unlike direct database connections, the connector exposes data with clear object names and fields.
-
Real-time data: Using the OData (Open Data Protocol) feed, users can access up-to-date information instantly or near real-time.
-
Data transformation: Power BI developers can leverage Power Query to filter, sort, aggregate, and prepare data for analysis before loading.
-
Interoperability: OData is a standardized protocol, ensuring compatibility across multiple platforms and data sources within your technology stack.
Getting Started
-
Obtain an API License Key: Request an API license key for your organization from Cybermetrics.
-
Download the Connector: Install the FaciliWorks Power BI Connector using the provided installer.
-
Connect in Power BI:
-
Open Power BI Desktop.
-
Use the custom connector to connect to your FaciliWorks OData feed.
-
Enter your API license key when prompted.
-
-
Prepare Your Data: Utilize Power Query to query, transform, and optimize datasets for your reporting and analytics needs.
This connector is ideal for organizations seeking enterprise-wide insights, real-time reporting, and streamlined Power BI workflows with their existing FaciliWorks data, whether deployed locally or in the cloud.
If you’re currently using Power BI with FaciliWorks, feel free to share how you’re using it or any challenges you’ve run into.