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
  • Anonymous's avatar
    Anonymous
    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.