How to use APPROXIMATE_COUNT_DISTINCT in Power BI

Welcome

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

1 REPLY 1

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.