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
cymorg's avatar
cymorg
Icon for Resolver I rankResolver I
7 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
      Icon for Resolver I rankResolver 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.

      • acitsme's avatar
        acitsme
        Icon for Advocate II rankAdvocate II
        6 years ago

        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.