Forum Discussion
Report Server October Release refresh fails
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.
Power BI TeamIn 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!
Thanks for the reply!!
I've done that and the connection was successful.
I bounced the server in hope but no luck.
The scheduler always says refreshing
And the data source looks as per below.
Also tried using OleDB connections instead of SQL server connections and still same response.
btw. I am using direct query with the SQL connections.
The refresh works when using Import connection.
Looks like the schedule is running and the output contains no errors.
Here is an example of the output from the RSPowerBI2017XXX file:
2017-11-14 13:18:08.5061|TRACE|5|AnalysisService XEvent: {
"Name": "PBIRS.AS.ExecutionStatistics",
"Use": "Info",
"Id": "539f329c-47e9-4528-a393-945fb34ebc9d",
"Time": "2017-11-14T03:18:07.5559345Z",
"Properties": {
"Summary": "Execution stats: time(Req-Start-UTC)=03:18:07.553, time(Req-Execute-UTC)=03:18:07.553, time(Req-Dispatch-UTC)=03:18:07.553, val(Req-ParsingThreadpoolType)=1, sum(Req-ParsingTasks)=1, sum(Req-ParsingQueueWaitingThreads)=4, sum(Req-ParsingQueueBusyThreads)=0, sum(Req-ParsingTime-ms)=0, sum(Req-ParsingWait-ms)=0, sum(Req-TCPRawBytes)=719, time(Req-TCPRequestStart-UTC)=03:18:07.553, sum(Req-HeapAllocated-kB)=3, sum(Req-HeapReallocated-kB)=0, sum(Req-HeapReallocs)=6, sum(Req-HeapReleased-kB)=1, last(Req-DiscoverType)=30, sum(Req-Duration-ms)=0, time(Req-ParseReqStart-UTC)=03:18:07.553, time(Req-ParseReqLoadEnd-UTC)=03:18:07.553, time(Req-ParseReqUTCLEnd-UTC)=03:18:07.553, time(Req-ParseReqEnd-UTC)=03:18:07.553, last(Req-Priority)=2, time(Req-Done-UTC)=03:18:07.553,",
"RequestID": "539f329c-47e9-4528-a393-945fb34ebc9d",
"ActivityID": "859d36b4-50a1-4dc5-8ce0-b968479aa2f0",
"ActivityType": "TPWM",
"ClientActivityID": "539f329c-47e9-4528-a393-945fb34ebc9d"
}
}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.