Forum Discussion

SimonPetrus's avatar
SimonPetrus
Frequent Visitor
1 year ago
Solved

ODBC Custom Connector - Disable Aggregate Types

Hi,

 

I've created a Power BI Custom Connector using Direct Query using a ODBC driver, but I want to disable some aggregate types (like "Standard Deviation", "Variance" and "Median") when used in Power BI. Is there a way to do this in the PowerQuery Data Connector file?

 

Thanks in advance!

Need Help
Tips and Tricks
  • v-priyankata's avatar
    v-priyankata
    1 year ago

    Hi SimonPetrus,

    Unfortunately, when utilizing Direct Query with an ODBC driver, you cannot manually disable certain aggregate functions, such as median, variance, and standard deviation, within the Power Query Custom Connector file itself. The connector is mostly responsible for connection and data retrieval; Power BI's query engine generally controls the aggregation behavior.

    Thanks,
    Priyanka.


1 Reply

  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    Hi SimonPetrus,

    Unfortunately, when utilizing Direct Query with an ODBC driver, you cannot manually disable certain aggregate functions, such as median, variance, and standard deviation, within the Power Query Custom Connector file itself. The connector is mostly responsible for connection and data retrieval; Power BI's query engine generally controls the aggregation behavior.

    Thanks,
    Priyanka.