Forum Discussion
count(distinct) for Direct Query
Hi, Am reading data from postgres to powerbi with direct query mode. count(distinct) is not working am pasting the error below.when i change it to import mode then its working. Error Message: ...
Yes am just using table and then in the visual,
per a day per a vendor i need distinct count of stores so am doing like below.
in the values i have given column and then am selecting count(distinct) like below
Anonymous , Please report an issue too -https://community.powerbi.com/t5/Issues/idb-p/Issues