Forum Discussion

iversa's avatar
iversa
Helper I
8 years ago

Refresh database view with new fields

I'm connecting to a PostgreSQL database view. I have made some changes in the view by adding and deleting some fields. How can I refresh the data in the Power BI report to reflect the new fields?

 

I deleted the view in the PostgreSQL database and recreated it and it seems now that Power BI does not see that view anymore

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Go into Query Editor and click the Source line of the query and then do a refresh preview. Look at your query and make sure that you are not doing a "remove columns" or "remove other columns" and such. You could always go into Advanced Editor, copy the query, remove it and then recreate the query.

    • iversa's avatar
      iversa
      Helper I
      8 years ago

      I got it but also is there a way to update the data source in Power BI online without having to re-publishing the report that is using the data source?

       

      I have more then one report in Power BI online that is using the same data source

      • v-xjiin-msft's avatar
        v-xjiin-msft
        Solution Sage
        8 years ago

        Hi iversa,

         

        As I know, if you only need to refresh the data in your data source. Power BI Service can handle it.

         

        However, if you have changed the schema of your data source. You have to refresh it on Power BI Desktop and re-publish those reports which are using this data source.

         

        Reference: https://docs.microsoft.com/en-us/power-bi/refresh-data

         

        Thanks,
        Xi Jin.