Working with Power BI Objects

Overview

Interacting with Power BI objects is a core functionality when integrating Power BI with Kognitos. This section covers how to fetch data, create and modify Power BI objects, and delete them when necessary.

Retrieving Data from Power BI

To fetch data from Power BI, you can use custom queries or direct commands. Below are examples of how to retrieve data using Kognitos.

Fetching Data using Custom Queries

To fetch data from Power BI using custom queries:

get powerbi's "PO Header File"s

Fetching Data using Direct Queries

To fetch data from Power BI using direct queries:

get powerbi's "PO Header File"s whose DOCUMENT_NUMBER is 616367

Fetching Specific Attributes

get the powerbiobject's VALUE_OF_PURCHASE_ORDER

Fetching Attributes from Retrieved Objects

get powerbi's "PO Header File"s  # <---- will return powerbiobject
get the answer's VALUE_OF_PURCHASE_ORDER  # <---- the answer is powerbiobject from 1st statement.