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