How to use APPROXIMATE_COUNT_DISTINCT in Power BI

Blackbeard87
Padawan

Is it possible to use the function APPROXIMATE_COUNT_DISTINCT in Power BI Desktop in a combination of a direct query?

Nowadays, a function like APPROXIMATE_COUNT_DISTINCT is essential to effectively (fast) analyze big data, so it is extremely important that this function works in Power BI in tandem with a Direct Query.

Hope you can help me.

Best Regards Semih

  • BI
1 REPLY 1

exa-ThomasB
Team Exasol
Team Exasol

@Blackbeard87   Looks like https://docs.microsoft.com/en-us/dax/approximate-distinctcount-function-dax  is still a preview function which only works for Azure SQL Database. 

Maybe in the future Microsoft will open their connector API so also other sources are supported. 

In the meantime I would recommend you to build views in Exasol which contain the approximate count distinct functionality.