How to get updated data into the PBIX file?

[croberts21]

I have Free PBI Desktop v2.100.1182 (64 bit free version) on Windows 10. We connect to a Postgresql database via an ODBC connection, which was recommended by Microsoft. This might affect whether I can do this or not. I'm still new to PBI and still doing tutorials on PBI so please consider me a beginner.

All my questions for the past 2 weeks are about a viz that shows all my time (hours) on a certain job, so I filter on a job and my employee id. One page in my report has all data in a table. I created this report (PBIX file) around Feb 26, 2022. The PBIX file seems to have all the data up until that point. I worked on this job on Mar 1 and 2 but there is no data in my PBI report for those dates. 

How do I refresh the data to see the hours I worked on this job for Mar 1 and 2? 

[Pragati11 · Accepted solution]

Hi @croberts21 ,

As you mentioned you are working with Power BI Desktop and using PostgreSQL connection to get data in Power BI, the simplest way to refresh the data in your Power BI Desktop file will be hitting the REFRESH button as shown in the screenshot below:

If the new data rows are in PostgreSQL database, they should appear in Power BI Desktop once the refresh finishes.

Let me know how you get on with this.

[Pragati11 · Accepted solution]

Hi @croberts21 ,

As you mentioned you are working with Power BI Desktop and using PostgreSQL connection to get data in Power BI, the simplest way to refresh the data in your Power BI Desktop file will be hitting the REFRESH button as shown in the screenshot below:

If the new data rows are in PostgreSQL database, they should appear in Power BI Desktop once the refresh finishes.

Let me know how you get on with this.

[croberts21]

Thank you very much! I didn't even see that button. This report has one table with 9 million records. Does it get all records all over again (which takes about 15-20 minutes) or does it only grab the newest or changed records?

EDIT: It grabbed all 9 million rows again. That seems to be the more accurate option, if records did change. 

[Pragati11 · Accepted solution]

Hi @croberts21 ,

Refersh will load the rows again to Power BI Desktop.

You can check about incremental refreshes here but it isa Power BI Service solution not the Desktop and it requires a Power BI license:

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview