ODBC Custom Connector - Disable Aggregate Types

[SimonPetrus]

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!

[v-priyankata · Accepted solution]

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.