Refresh database view with new fields

iversa · ‎04-23-2018

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

Greg_Deckler · ‎04-23-2018

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.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

iversa · ‎04-23-2018

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 · ‎04-23-2018

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.