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?   ...
Need Help
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.