Forum Discussion
Advocate IIOLE DB or ADC error: [outsource.error] An error happened while reading data from the provider
Advocate IIConfirming that I do indeed use the Get Data -> SQL Server interface.
The SQL Servers are located on physically different machines in completely different cities. The one in Toronto (primary server) works fine. The one in Atlanta (secondary server) is the one I have trouble with.
Data preview works fine on the problem tables. I can also manually refresh the table in question from the "Tables" panel in the Canvas screen (Ellipses --> Refresh Data). The only time the query fails on the secondary (Atlanta) server is when I refresh the entire report at once.
Super UserIf you are able to see the data in the query editor, then I really doubt the data provider is the issue
I don't know your proximity to the Atlanta or Toronto server, so not sure whether query latency would be the issue
However, it seems that somewhere along the path to the Atlanta server, something is terminating the connection
I can't say for sure, but it seem that a rounter or network appliance is terminating the tcp connection, maybe b/c the connection is idle longer than some configured timeout
I would recommend possibly having one of your network guys install fiddler or wireshark on your desktop to maybe gain some insight into the network traffic from/to your desktop to the Atlanta server
Sorry I can't be of any further help,
Hi viralmehta9 - I ran into the same issue a couple of minutes ago and managed to update the Command Timeout following these steps:
1) On the query Editor, select the query you wish to update.
2) Click on the Source's Gear Icon
3) Enter the desired command timeout minutes
I hope this helps!- hugoberry
Responsive Resident
You can play with various options in the Sql.Database access data function in your power BI query.
Loooking at the MSDN for this function https://msdn.microsoft.com/en-us/library/mt260902.aspx there are plenty options to choose from. My favourite ones are CommandTimeout, MultiSubnetFailover and MaxDegreeOfParallelism.
- gsalas
I think the ComandTimeout function was the key. I have set it to 30 minutes and now everything is loading smoothly. Thanks!
Thanks Anonymous . I had shifted my approach. But thank you for response.
- gsalas
Thanks for your help. Unfortunately, we don't really have a network "guy." Just my DA who says that the SQL Server is runing the queries fine. The servers are leased, so we have little to no control over the connectivity settings. Hopefully Microsoft will build some kind of "buffering" into the report refreshes function so that an interrupted connection doesn't kill the whole refresh.
- blopez11
That is awesome, and great information to know
- gsalas
I had some success increasing the command timeout to 30 minutes, but I am still getting the error message. What do the other two commands mean and what setting would you recommend?
Hi.. thanks for mentioning your solution. Can you help me understand how to set the commandTimeout to greater value. I am facing same issue with my Power bi desktop reports.
Thanks
its shame no one answered this gentlman ðŸ˜
