cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
acanepa
Resolver I
Resolver I

Postgres: EnableFolding

Postgres connector added native queries since the September release for PowerBI Desktop.

Before the update, the M language was like this

 

PostgreSQL.Database("server", "db", [Query="query"])

 

 

After the update the syntax change to this:

 

 Value.NativeQuery(PostgreSQL.Database("server", "db"), "query", null, [EnableFolding=true])

 

 

This applies each time you create or modify a query. The funny thing is that the old code for Postgres still works as before.  

The issues relies that if you publish your workbook with the latter syntax, the report will not update. So, the syntax would have to be changed to:

 

 Value.NativeQuery(PostgreSQL.Database("server", "db"), "query", null)

 

 

This is a real pain because you can modify queries forgetting completely that the last part was added – [EnableFolding=true]. So, you need to spend the next 30 minutes into fixing the query to the dashboard work again.

 

An idea has been raised but I don't trust they would take it seriously

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38626369-query-folding-enable-dis...

 

The problem is the Microsoft team create this feature without thinking in the Postgres users that don't use Native Queries as my self. This means that the feature is has been converted into a pain, and the request from my side and other people is to fix the problem that originally Microsoft team has already generated by themselves. I tried to raised the issue yesterday with Amanda, but they didn't get the question through, thinking it was a "new feature".

 

Similar issue raised in Stackoverflow

https://stackoverflow.com/questions/57927599/powerbi-enablefolding

2 REPLIES 2
jpd99
Frequent Visitor

Has this been fixed yet?

jpd99
Frequent Visitor

I have the same issue. Very annoying

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.