Refreshing data from SQL server online

[Anonymous]

I ran an import query against an sql server on power bi desktop and then uploaded the file on to powerbi service. I've set up the gateway and want the data to refresh when I click refresh but it does not update with the latest data from the query. I am not sure if the query was actually uploaded or just the data from my query when I put on power bi service. How can i configure power bi service to run the query when I click refresh?

[Greg_Deckler]

@Anonymous Sounds like you are hitting the refresh button in the Service on the report page. That simply refreshes the report visuals, it doesn't actually refresh the data. You need to schedule a refresh on the dataset.

[Anonymous]

@Greg_Deckler 

Never mind it is refreshing the data but the report is just not reflecting it. Do you know how I can update the report? I don't see a refresh option on it.

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

If you configure the gateway correctly, you can click the two buttons to refresh. You can see the refresh history in dataset>>more options>>setting>>refresh history.

If you have opened the report, you can refresh to get the latest data through the refresh button on the browser and the refresh button on the report (Make sure that the dataset has been refreshed at this time).

Here you can view the latest update time of the report:

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

If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey