Forum Discussion

gsalas's avatar
gsalas
Icon for Advocate II rankAdvocate 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
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi gsalas,

 

To troubleshoot and narrow down the issue, could you try making a copy of your pbix file, and delete the particular table which raises the refresh issue, to see if the "Refresh All" works or not?(Note: Make sure you're using the latest version of Power BI Desktop):smileyhappy:

 

In addition, are you using the ODBC connector to get data from your servers in Power BI Desktop? If so, what provider are you using? 

 

Regards

gsalas's avatar
gsalas
Icon for Advocate II rankAdvocate II
9 years ago

I think it's an ODBC connector.  I have no idea. I just log into the SQL Server via Power Bi.

 

I deleted the tables as a test and the refresh works perfectly.  But that isn't a solution.  I HAVE to have the other two problem  tables in my report - non negotiable.

 

 

  • blopez11's avatar
    blopez11
    Icon for Super User rankSuper User
    9 years ago

    Just so I understand

    Do the error happens in Power BI service when a refresh is scheduled?

    If so, did it just start happening or has it always happened

    Can you refresh your data with no issie in Power BI Desktop?

    You said you connect to two different SQL servers

    Is the issue only happening for one of the servers?

    Sorry for all the questions, just trying to understand in case I can help

    • gsalas's avatar
      gsalas
      Icon for Advocate II rankAdvocate II
      9 years ago

      Do the error happens in Power BI service when a refresh is scheduled?

      These are manual refreshes in Power Bi Desktop only

      If so, did it just start happening or has it always happened

      It has always happened, but not every single time.  50/50

      Can you refresh your data with no issie in Power BI Desktop?

      No - Power Bi Desktop is where I get the error message

      You said you connect to two different SQL servers

      Is the issue only happening for one of the servers?

      Yes - the issue only happens on the secondary server.

      • blopez11's avatar
        blopez11
        Icon for Super User rankSuper User
        9 years ago

        Interesting.  If you are connecting through Get Data->SQL Server, then likely you are using the canned provider installed with Windows.  So while it could be the cause, I doubt it

        If you can pull data from one sql server and not another, I don't think it is an issue with the data provider

        I'm wondering if it is a networking issue (firewall) between your desktop and the server

        Are the sql servers installed on physically different servers or virtual machines, or are they on the same physical server?

        Can you preview the data from the bad sql server in the query editor?