Forum Discussion
Direct Query and PostgreSQL
Hi, Anonymous
You may have to use npgsql then use powerbi connector to achieve dq mode.
Reference:
Power Query PostgreSQL connector - Power Query | Microsoft Docs
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Super UserSome useful links for you, >>Solved: Connecting to postgresql with direct query mode - Microsoft Power BI Community
1. https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
2. https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
3. https://niftit.com/connecting-power-bi-to-postgresql/
Hope it helps!
Regards,
Ritesh
Thank you. I have already looked at those sources and cannot find any reference to direct query. I am hesitant to switch to npgsql unless it will guarantee that I can then do direct query.
- v-janeyg-msft
Community Support
Hi, Anonymous
You may have to use npgsql then use powerbi connector to achieve dq mode.
Reference:
Power Query PostgreSQL connector - Power Query | Microsoft Docs
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey