Forum Discussion
Report Server October Release refresh fails
Hi,
So I am having trouble getting data to refresh with a SQL Server Connection in the new version of Power BI Report Server.
I created a brand new report in the October Report Server Desktop version with a connection to a simple view in SQL Server.
In the Desktop tool the data will refresh fine.
I then save the report to the report server and it renders fine.
If I change the data in SQL and hit refresh on the server nothing happens.
I went to Manage and then data sources and entered my credentials (same as what is used on the Desktop version).
Hit refresh and still no data change.
I then created a schedule to refresh the data hourly and the data did not change.
In the Schedule Refresh page i hit refresh now and the status just hangs on 'refreshing'.
Looking at the log file i keep seeing this error
2017-11-08 12:00:42.3443|ERROR|19|Failed to get connection string for model | RequestID = 44ccb0b2-29ee-8b56-c3f6-12c3e1e167ec ClientSessionID = 9d75fe2b-ee23-96a5-400c-5259dd79a716 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model
In the data model I can't edit the connection string.
Am i missing a step?
Kind regards
Dean.
So I found the problem.
There were 2 data sources in the model pointing to the same database and for some reason I could not enter credentials for the second data source as the second one disn't show up.
The reason there were 2 was that the database name was all lower case in one source and camel case in the other.
I used the advanced editor in desktop to rename them to be unique and then there was one source and data refreshes fine.
5 Replies
In the Portal can you go to the management page for that report and click the Data Sources tab. From there can you try to 'Test connection' for each of the data sources that you have in the report and let me know if that works? Thanks!
