Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
  • lbendlin's avatar
    lbendlin
    2 years ago

    Instead of using the Query option directly I recommend you try the Value.NativeQuery variation. That may make it easier to consume the parameter.