PBI Desktop (April 2020) composite model with dq to postgres. Any field or calculated measure added to a table or matrix visual gets the error "Direct query may not be used with this data source - please consider moving to a supported data source."
There is one fact table (only 70M rows) set to direct query and a corresponding aggregate table set to import, both use Value.NativeQuery connection like here
Close and apply, add a dax date table, set aggregations, create some measures, everything works fine
Then, when I put any field or measure from the fact table onto the canvas, it gives the error above. I was able once (not since) to put the month field from the date table into a table visual first, and then add a couple measures from the fact table and that worked. But as soon as I created and added a new measure, it threw the error. Its not slow and there's no spinning wheel of death, just pops up the error. Hit refresh on the home tab, that works fine. Performance monitor catches dax query, but no direct query and I'm pretty sure the aggs are good (simple group by and counts). this pbix is 100kb.
Is there some limitation I'm overlooking? This dataset works with Import but then its a nuisance 30GB pbix with a third of the records I need.
