How to refresh table when power bi starts?

[Anonymous]

I have a program that transforms the data of a csv file and creates a new file with said data. After creating the file it automatically starts power bi. The program always store the file in the same path with the same name, so the only thing that power bi has to do is refresh.

Is there a option where power bi refreshes the table on startup automatically or do I have to do it manually?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Power BI Desktop only allows manual refresh currently.

This is at idea/feedback level alone. May be , hopes Power Bi will implement this in nearby future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback -https://ideas.powerbi.com/ideas/idea/?ideaid=706d19ad-81b8-453f-8069-b75dcc6a4fe8

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[Anonymous]

Thanks for the info! Hope the feature will be added asap

[amitchandak]

@Anonymous , Not sure I got it. I think Incremental load can do that.

Incremental Load

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/

https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-or-date-instead-of-the-default-datetime/

[Anonymous]

Hi @amitchandak , thanks for the answer.

I will try to explain it again:

I have a program which creates a .csv file. Power BI already has that exact table. Now after my program created the .csv file, it automatically starts the power bi report. Power BI already knows where the file is, so at the moment I still have to click on home and then on “Refresh”.

I need Power BI to refresh automatically when it is opened, only once.

Here’s a visualization of the whole process: