cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
acitsme Frequent Visitor
Frequent Visitor

++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver ++++

Dear Microsoft team,

I spent the whole day since suddenly my report stop refreshing automatically after I changed a query against postgres. Never ever faced such error earlier: 

 

---

Underlying error code-2147467259 Table: blablabla.
Underlying error message'EnableFolding' isn't a valid option for this function. Valid options are: (none)

---

 

Now I understand that latest Desktop version creates a m language statement like:

= Value.NativeQuery(PostgreSQL.Database("stpgpsdev.memc.com:5433", "postgres", [CreateNavigationProperties=false]), "select * from gen_site", null, [EnableFolding=true])

while previous version was creting statement like:

= PostgreSQL.Database("scmprddb1.memc.com:5448", "scmprd", [Query="select *, #(lf)planned_gm_date-deliv_date days_delay,#(lf)doc_num||item||shipping_plant as docitemplant#(lf)from shipments#(lf)where matl_grp IN ('EPI','GR1','MMT','SOI','SUBSTRATE')", CreateNavigationProperties=false])

 

There is no problem running the new version from desktop but NOW REFRESH ON SERVER ALWAYS FAILS

 

PLEASE FIX IT!!!!

 

 

 

9 REPLIES 9
cymorg Regular Visitor
Regular Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

Have you tried opening the .pbix file from PowerBi.com/GetData?  I've found changes to connections when published via PBI Desktop don't always get updated in PBI Service.  Opening the file via PowerBI.com seems to force the service's copy of the connection to be refreshed with any changes.

acitsme Frequent Visitor
Frequent Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

I tried to open the file from power bi service following this steps but data refresh still throwing same error. Is this what you meant "with open from Power.com/getData?

 

https://community.powerbi.com/t5/Desktop/how-to-open-an-old-Power-BI-document-in-power-BI-online/m-p...

 

cymorg Regular Visitor
Regular Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

Yes, that's what I meant... Go to PowerBI.com, click on "Get Data", go to "File" and open your .pbix.  Opening the file in this manner seems to fix similar issues for me.  I was connecting to a Web API rather than Postgres.  PBI wouldn't update the credentials via online "Data source credentials".  Opening the .pbix file from within the online service seemed to do the trick.

acitsme Frequent Visitor
Frequent Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

Thank so much for your suuggestion.

 

This could be a valuable temporary workarond but I'm seraching for a stable a definitive solution ;-).

 

I'm going to open a ticket to Microsoft. 

 

 

 

prguha Visitor
Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

removing [EnableFolding=true] from edit queries>select the query>advanced editor worked for me

tm5_dwh Frequent Visitor
Frequent Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

Same happening with me since recent update.This messes up the auto refrehses and every time 

Highlighted
tm5_dwh Frequent Visitor
Frequent Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

Same happening with me since the recent update. This messes up the auto-refreshes and every time  I have to manually change in the Power Query.

acitsme Frequent Visitor
Frequent Visitor

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

yes this is the reccomandation from Microsoft too


@prguha wrote:

removing [EnableFolding=true] from edit queries>select the query>advanced editor worked for me


 

Re: ++++ Power BI no longer refresh data from Postgres if query are created with latest desktop ver

Ok to remove manually [EnableFolding=true]  from the advanced editor.

But without this option, in Power BI Desktop, the Direct Query is no longer working 😞

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 435 members 4,309 guests
Please welcome our newest community members: