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 ...
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.

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.
      • JackSprat's avatar
        JackSprat
        Helper I
        8 years ago

        Getting this issue in the August release.  Can't connect to the data, and can't seem to find where to fix the data connections insiode the SSRS administration tools ( well I guess they are PBIRS tools now).

    • JackSprat's avatar
      JackSprat
      Helper I
      8 years ago

      Getting this same issue.  I can't seem to get the Power BI desktop (August 2017) to save a new report to the Power Bi Server (August 2017), because it says it isn't there. But it is there and the RS config is showing the proper URL.  So instead I upload the report from inside the PBIRS web page successfully, but then the data connection disappears and the report throws an error saying:

      Something went wrong
       
      Unable to load the model
      Please try again later or contact support. If you contact support, please provide these details.
      Request IDc7b8a6e3-cad4-cd46-2896-ebe47d279af4
      TimeWed Aug 30 2017 11:49:49 GMT-0700 (US Mountain Standard Time)
      Version14.0.600.379

       

    • Krishnanv's avatar
      Krishnanv
      New Member
      8 years ago

      I created a Power BI desktop visual by importing data from CSV files. I was able to save it in the report server, but, while running it, it threw the following errors:

      We couldn't connect to the Analysis Services server. The server forcibly closed the connection. To connect as the user viewing the report, your organization must have configured Kerberos constrained delegation.

       

      Any suggestions/solutions?