Forum Discussion

EricPierre's avatar
EricPierre
Frequent Visitor
9 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
    9 years ago

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

gemidriver's avatar
gemidriver
Icon for Helper II rankHelper II
9 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

 

JackSprat's avatar
JackSprat
Icon for Helper I rankHelper I
9 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