Forum Discussion
parameterized direct query in powerBI
Hi lbendlin ,
In databases supported by PowerBI Direct query its mentioned PostgreSQL is support, direct query with parameters for PostgreSQL works fine in my PowerBI desktop version, but issues is when publised to PowerBI serverice.
DB supported by PowerBI Direct Query : https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
But you are looking for parameterized direct query, right?
yes
basically paramterized direct query currently not working in PowerBI Service, the same report with another table without parameter query working fine
actually we choose this direct query option becasue we were not able to plot calculated date field in a any visuals( mentioned issue in this link : https://community.powerbi.com/t5/Desktop/Data-visualization/m-p/2370040) , so we thought we get the calculation done at back end through direct query. any idea if we can plot caculated measure in any visuals ?
