Forum Discussion
OLE DB or ADC error: [outsource.error] An error happened while reading data from the provider
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.
I think the ComandTimeout function was the key. I have set it to 30 minutes and now everything is loading smoothly. Thanks!
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!Thanks Anonymous . I had shifted my approach. But thank you for response.
That is awesome, and great information to know
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 ðŸ˜
