This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
The following connector article is provided by KX Systems Inc., the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the KX website and use the support channels there.
| Item | Description |
|---|---|
| Release State | Preview |
| Products | Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2) |
| Authentication Types Supported | Username/Password OAuth |
The connector enables Microsoft Power BI users to remotely connect, explore, query data, preview tables, and harness the power and performance of kdb Insights Enterprise analytics before importing datasets into Power BI for visualization.
Ensure the following prerequisites are met before proceeding:
kdb Insights Enterprise 1.11.0 or above is installed and running at least one database.
Permissions to query data on the running databases.
To make the connection, follow these steps:
Open Microsoft Power BI Desktop or Power BI Online.
Select Get Data:
Search for KX kdb.
Select KX kdb Insights Enterprise.
Select Connect.
Enter the URL for your kdb Insights Enterprise deployment.
Select OK.
You're prompted to sign in if you haven't signed in recently or have never signed in:
If you haven't signed in recently or have never signed in, select Sign in. The button is named Sign in as a different user if your sign-in credentials expired or are no longer valid.
If your credentials are valid, the Connector popup displays that you're currently signed in and you can select the Connect button.
The Navigator dialog box displays all the running databases and tables for your chosen host on the left. Selecting a table returns a preview of the selected data using the kdb Insights Enterprise getData REST API.
The parameters available on the Navigator allow you to use the power of kdb Insights Enterprise analytics to filter, group, and aggregate data by restricting the data being loaded and bringing you the performance of the kdb Insights database.
| Parameter | Details |
|---|---|
| Start Time | Applies to the partitioned column and is ignored for nonpartitioned tables |
| End Time | Applies to the partitioned column and is ignored for nonpartitioned tables |
| Filter | Filters out certain rows |
| Aggregation | Filters the columns and/or aggregates the rows being returned |
| Group By | Group the results of an aggregation based on specific columns |
For more information, visit the following resources:
Training
Module
Utilizar Power Query para cargar datos en Dataverse - Training
Aprenda a sincronizar datos de diferentes orígenes con una tabla de Microsoft Dataverse usando Power Query y los flujos de datos de creación en Power Apps.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demostrar métodos y procedimientos recomendados que se alinean con los requisitos empresariales y técnicos para modelar, visualizar y analizar datos con Microsoft Power BI.