Skip to content

[Rule Request] Databricks Implementation 2.0 is not allowed #68

@ConstancaElias

Description

@ConstancaElias

I have a table in my semantic model that is connected to Azure Databricks. The connection to Databricks is defined in Power Query using the following M expression:

let
    Source = Databricks.Query(ServerHostname, HTTPPath, [Catalog=null, Database=Database, EnableExperimentalFlagsV1_1_0=null,Implementation="2.0"])
in
    Source

In Power BI Desktop, the parameter Implementation = "2.0" is required for the refresh to work correctly.
However, when the model is published to Power BI Service, the query must not include this parameter.

For this reason, I would like to create a BPA rule that validates whether a Databricks query contains the parameter Implementation = "2.0".

The expected behavior of the rule is:

  • If the Databricks query contains Implementation = "2.0", the rule should raise an error.
  • If the parameter is not present, the rule should pass.

I am looking for guidance on how to implement such a rule. Thank you!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions