Forum Discussion

vishy0501's avatar
vishy0501
Helper I
6 years ago
Solved

refresh dataset concept

HI ALL,   Would like to know whenever we publish a report from the desktop file does the refresh of the data happens automatically while the report is getting published. if not what is the value th...
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi vishy0501 

     

    If you connect the SQL server by Direct query mode and configure the gateway but not set schedule refresh, you should know the only refresh depends on the tile refresh. A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results.  that the refresh time indicated in the stamp. If you connect SQL server by Import mode and didn't set the schedule refresh or manual refresh, the stamp time shows the publish time from desktop to service.

     

    More details please refer to the official document: https://docs.microsoft.com/en-us/power-bi/refresh-data

     

     

     

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi vishy0501 

 

The refresh of published data won't happen automatically always, but depends on the data source type. If the datasource is from Onedrive/Sharepoint, the refresh happens every one hour by default, you can also set the schdule refresh under setting. But if the datasource is a on-premise file, you'll need to install the gateway to enable the refresh. 

 

More details please refer to the official document: https://docs.microsoft.com/en-us/power-bi/refresh-data

 

  • vishy0501's avatar
    vishy0501
    Helper I
    6 years ago

     Hi ,

    Thanks for your prompt reply however i have a question on the same

    1. My datasource is SQL and when i publish in dataset section there is a option which says the data set refresh has been succeed at a particular time stamp , how to interpret that message.

    Note - I didnt refresh it manually and have scheduled the refresh as well and i am not able to see this message in the schedule refresh history section as well.

    below is the screenshot of the same. 

    v-diye-msft 

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      6 years ago

      Hi vishy0501 

       

      If you connect the SQL server by Direct query mode and configure the gateway but not set schedule refresh, you should know the only refresh depends on the tile refresh. A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results.  that the refresh time indicated in the stamp. If you connect SQL server by Import mode and didn't set the schedule refresh or manual refresh, the stamp time shows the publish time from desktop to service.

       

      More details please refer to the official document: https://docs.microsoft.com/en-us/power-bi/refresh-data