/
separators in the folder value in Honeydew metadata (e.g. folder/subfolder
)formatstring
values (Power BI DAX documentation):
yyyy-mm-dd
#,##0;-#,##0
datacategory
values:
Latitude
Longitude
PostalCode
City
StateOrProvince
Continent
Place
WebUrl
ImageUrl
Barcode
Power BI Referential Integrity | Power BI Cross-Filtering | Honeydew Join Type (from many to 1) | Honeydew Cross-Filtering |
---|---|---|---|
No (Power BI default) | Single (Power BI default) | LEFT | One-to-many |
No | Both | LEFT (Honeydew default) | Both (Honeydew default) |
Yes | Single | INNER | One-to-many |
Yes | Both | INNER | Both |
directQuery
: No performance impact on queries. The entity appears as a separate virtual table.dual
: Speeds up queries that only need entity attributes. There is no performance impact on other queries. Use for dimensions with 1M rows or less.import
: Can negatively impact the performance of queries that join across entities. Not recommended - when in doubt, always prefer dual
.name
, Name
, and NAME
),
Power BI may randomly choose one spelling and align all other values to that spelling.
When used as a filter, it might only send the selected spelling, potentially omitting other matching data.To prevent this, the best practice is to standardize the column’s case (e.g., converting all values to uppercase) within the data definition in the Honeydew source.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 Power BI.