Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

AJ_Clark

Power BI v2.85.681.0+ breaks working report (Works in August 2020) - Direct Query Postgresql

Submitted by Resolver I on ‎09-30-2020 08:16 PM

Power BI v2.85.681.0+(and above) is throwing a query folding error on direct query to postgresql data connections that is not present on the August 2020 version of power bi: 

 

August 2020 Build:

AJ_Clark_0-1601521911853.png

 

September 2020+ Build (exact same report)

AJ_Clark_1-1601522109143.png

more details of the errors can be found here: https://community.powerbi.com/t5/Desktop/Power-Bi-v2-85-681-0-Breaking-a-Working-Report-Direct-Query... 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎10-04-2020 09:26 PM

@AJ_Clark 

 

The latest version 2.85.985.0 64-bit (September 2020) works fine for me. Try to recreate the report.

 

AJ_Clark
Resolver I
Resolver I
‎10-06-2020 08:49 PM

@v-chuncz-msft Thanks. So I rebuilt the report and realised that the code to create a calcualted column works in August but fails in September. I re-wrote that query and it's all fine now. Thanks! 

Idea Statuses