Forum Discussion
DirectQuery error when loading visualization from PostgreSQL table using Dynamic M query parameter
I'm trying to create a line graph in Power BI desktop from an on-premises PostgreSQL database table via DirectQuery while using a Dynamic M query parameter, and the visualization fails to load. I get...
Instead of using the Query option directly I recommend you try the Value.NativeQuery variation. That may make it easier to consume the parameter.
Your SQL code is missing the single quotes around the text value.