Forum Discussion

gsalas's avatar
gsalas
Advocate II
9 years ago

OLE 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...
Need Help
gsalas's avatar
gsalas
Advocate II
9 years ago

I think the ComandTimeout function was the key.  I have set it to 30 minutes and now everything is loading smoothly.  Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Anonymous . I had shifted my approach. But thank you for response.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    its shame no one answered this gentlman ğŸ˜­