Forum Discussion

EricPierre's avatar
EricPierre
Frequent Visitor
8 years ago
Solved

"report server" refresh data

When consuming a Power BI report on Report Server, to be able to use it as a dashboard, I would like to set an automated refresh. However, I found the information to do it for published reports, but not the report server version.

Refresh
Report Server
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Currently Report Server only supports SSAS live connections and hence there is no need for a refresh.

11 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Currently Report Server only supports SSAS live connections and hence there is no need for a refresh.

    • gemidriver's avatar
      gemidriver
      Helper II
      8 years ago

      the report server can now talk to SQL Server directly - not limited to SSAS

      so i have report created - via direct query to SQL

      what is the method of refreshing the data?  we used the enterprise gatway with the cloud version

    • gemidriver's avatar
      gemidriver
      Helper II
      8 years ago

      now that the report server can talk to SQL, without the limitation of using SSAS, what is needed to use in order to refresh live reports?

      i have a sql report which i created via import - unable to refresh

      i have a sql report which i created via direct query - unable to show data at all

      Unable to load the model
      Please try again later or contact support. If you contact support, please provide these details.
      Request IDc4fe1fc0-6aaf-18b3-468e-be25b3f0f727
      TimeWed Aug 30 2017 09:24:04 GMT+1000 (AUS Eastern Standard Time)
      Version14.0.600.379

       

      • xpherion's avatar
        xpherion
        Advocate II
        8 years ago

        Are you using August Preview version or June GA version?

         

        Since this is an early preview, there are a few limitations to keep in mind as you try it out. Please note that we plan to support all the below scenarios when we make the GA release available in later in 2017. Some current limitations are:

        • Scheduled data refresh is currently not available for reports using imported data.
        • Direct Query data connections are not currently supported.
        • Scale-out environments for Power BI Report Server are not officially supported using the preview release.
        • Reports must be smaller than 50 MB in size.
  • Grumelo's avatar
    Grumelo
    Advocate II
    8 years ago

    My Report is consuming data from SharePoint spaces, once shared on PBI Report Server the only way I found to refresh the data is: Edit in Power BI DeskTop / Refresh / Save.

     

    I'm expecting a schedule refresh feature. Is it coming soon ?

    • xpherion's avatar
      xpherion
      Advocate II
      8 years ago

      Scheduled resfresh is coming in the fall release (maybe end of October 2017). Also there is going to be (compressed data) file size limit.

      • Ruksuro's avatar
        Ruksuro
        Helper III
        8 years ago

        Hi xpherion,

         

        Is this feature guaranteed to be added at some point? For us this is considered a pre-requiste befoore we can use report server.

         

        Thanks for your time,

         

        Harry.