Forum Discussion
gsalas
Advocate II
Advocate IIOLE DB or ADC error: [outsource.error] An error happened while reading data from the provider
Hi All - I connect to two different servers when I run my power bi queries. The issue is that when I run a data refresh (run daily) I am consistently getting stuck at one particular table as part of...
hugoberry
Responsive Resident
Responsive ResidentYou 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.
gsalasAdvocate II
Advocate III 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?