Forum Discussion

acitsme's avatar
acitsme
Icon for Advocate II rankAdvocate II
7 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

acitsme's avatar
acitsme
Icon for Advocate II rankAdvocate 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.