report does not update

[mohammadamin-s-]

Hello, I use power bi report server. I get the data from Google Sheet, but when I change the information in Google Sheet, it is not updated on the server, and I have to open and refresh Power Bi Desktop every time and save it on the server. What should I do for my report to be online on the server?

[v-luwang-msft · Accepted solution]

Hi @mohammadamin-s- ，

Since your data source is Google sheet. so your connection method is Import, when there is only Direct Query and Live Connection, when you open the report, a query is sent to the data source to get the latest data. And in import mode, you need to configure scheduled refresh if you want to refresh the data.

Scheduled refresh is specific to Power BI reports with an embedded model. Meaning you imported data into the report instead of using a live connection or DirectQuery. When importing your data, it is disconnected from the original data source and needs to be updated to keep data fresh. Scheduled refresh is the way to keep your data up to date.

Scheduled refresh is configured within the management section of a report. For more information on how to configure scheduled refresh, see How to configure Power BI report scheduled refresh.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien