Forum Discussion

acitsme's avatar
acitsme
Helper II
6 years ago

++++ 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!!!!

 

 

 

Need Help

10 Replies

  • prguha's avatar
    prguha
    Regular Visitor
    6 years ago

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

    • tm5_dwh's avatar
      tm5_dwh
      New Member
      6 years ago

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

    • tm5_dwh's avatar
      tm5_dwh
      New Member
      6 years ago

      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's avatar
      acitsme
      Helper II
      6 years ago

      yes this is the reccomandation from Microsoft too

      prguha wrote:

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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 :(

  • cymorg's avatar
    cymorg
    Resolver I
    6 years ago

    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.

      • cymorg's avatar
        cymorg
        Resolver I
        6 years ago

        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.