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 ...
Need Help
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 :(

      • MBF's avatar
        MBF
        Frequent Visitor
        6 years ago

        The problem with removing it is that every time you edit the Source via the UI, and then save a change, the setting returns.
        Really just need a fix, or for the setting to be ignored if it's invalid.