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
@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.