Connect postgresSQL To PowerBi Desktop and working through direct query

[Anonymous]

I am facing this issue while using direct Query in Power Bi desktop . Sometime its working fine but other time it is creating issue.

[Anonymous]

Hi Jai-Rathinavel ,thanks for the quick reply, I'll add more.

Hi @Anonymous ,

If the problem only occurs in Desktop and runs normally in Power BI Service, this should be a known issue. This problem occurs in 'direct query' or 'composite model'. You can switch the connection mode to 'import' first. Engineers are investigating the cause of this error and I will let you know if there is any progress.

Best Regards,
Wenbin Zhou

[Jai-Rathinavel]

@Anonymous Try filtering the data and work with import mode. Switch back to direct query mode and publish to service once you have created your DAX logics. Check if the visuals are throwing the same error in service. Thanks