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.
Last updated
Was this helpful?