rsDataShapeQueryTranslationError

Hi Anonymous,

Thanks for testing further and providing details. Since you need to use DirectQuery for live PostgreSQL data, the best workaround is to reduce the number of columns in each visual rather than changing the storage mode. Typically, this means splitting a large table into multiple visuals, such as a “main info” table and a “details” table, or using a drillthrough page. You could also move some fields to a separate report or drillthrough page, instead of displaying everything in one visual. Alternatively, if possible, you might create a database view in PostgreSQL that only includes the necessary columns to keep the model and visuals simpler.

This appears to be a product limitation rather than a configuration issue. If these workarounds don’t solve the problem, you may want to open a support ticket with Microsoft to have them review your model and check for any internal settings that could be adjusted for your environment.
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

Thank you.