Power BI Model Reader

Reads data from Power BI using a DAX query.

Currently the node only supports the basic data types returned by the REST API (Strings, Number (Double), Booleans). The data types can be converted to other data types with nodes like String to Date&Time.

Power BI limits the amount of data which can be requested in one call. The actual limit depends on the number of values and rows. To access all of the data this node can be used multiple times with the appropriate window functions like TOPNSKIP or WINDOW.

To ensure that the data is up to date before executing this node the Refresh Power BI Semantic Model node.

Options

Workspace
The workspace which contains the Semantic Models. The first option, “My Workspace”, always refers to the private user workspace. (The workspace is referenced by its ID.)
Semantic model
The Semantic model (also known as dataset) to read. (The model is referenced by its ID.)
DAX query
The DAX query to evaluate. See node description for limitations regarding output size. The query
EVALUATE
    'table_name';
can be used to just read a table with a given name. The table name can for example be found in the Power BI (Web) interface.
If returned data was limited because of result size
Power BI limits the result size of DAX queries (see here). This setting determines how to handle a truncated query result due these limits or other errors.
  • Fail: Fail node execution
  • Warn: Set a node warning
  • Ignore: Do nothing

Input Ports

Icon
Microsoft/Azure credential (access token)

Output Ports

Icon
Read table

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.