Forum Discussion
Automatic Data Refresh - How to do it?
You can achieve this by schedule refresh for please follow the link
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
The main purpose of Power BI Desktop is to build reports. The Power BI Service (online) is where reporting is viewed from.
As mh2587 mentions, it's possible to set up a scheduled refresh cycle to keep the online reports up to date automatically. This scheduled refresh is like clicking refresh in the desktop app but updates the data stored online (but not your local PBIX file) and prevents you from having to republish whenever you want to update the data.
To bring the desktop file up to date, you click refresh in the PBIX or download a copy from the online service. There usually isn't much need to keep the PBIX always up to date since that file is generally used for building a report rather than viewing and sharing it.
I got so lost today! About 4 hours. Bringing a client on to Power BI because I told him how great it was. Now, Microsoft has made this so much more complicated! I reviewed all of the documentation, installed a "Gateway", never heard THAT one before. And, nothing works! After all of the options I tried, I see no options to auto-update anywhere! It used to be that you just click an option in you PBI report! Easy! Microsoft documentation always has been written for software engineers only. I would love to see precise, practical instructions written for this process. Many software companies are making things easier, not harder. It's not enough to know Power BI anymore, now we have to be computer engineers to make everything tie together! Why?