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

 

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?