Direct Query

Direct Query support is in Preview. Contact us to enable.

Import

PowerBI can import data from dynamic datasets in Snowflake.

With a VIEW or a TABLE

Dynamic datasets can be set up deployment to Snowflake.

The resulting VIEW or TABLE can be used for a Data Import.

With Snowflake Native Application

Create a blank query, and open advanced query editor to write:

let
    Source = Value.NativeQuery(
            Snowflake.Databases(
                "SnowflakeHost.snowflakecomputing.com",
                "VirtualDataWarehouse",
                [Role="Role"]
            ){[Name="Database"]}[Data],
            "
            CALL HONEYDEW_APP.API.SELECT_FROM_DYNAMIC_DATASET(
                'workspace',
                'branch',
                'dataset');
            ",
            null,
            [EnableFolding=false]
    )
in
    Source

Given Snowflake connection parameters (host, warehouse, role and database) and Honeydew workspace, a working branch in it (usually would be prod), and a dynamic dataset dataset.

This calls a stored procedure to retrieve dynamic dataset data to PowerBI.