cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Frequent Visitor

I have the same issue. Very annoying
Frequent Visitor

Has this been fixed yet?

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors