Forum Discussion
Advocate IIOLE DB or ADC error: [outsource.error] An error happened while reading data from the provider
Advocate III 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.
Super UserJust 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
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
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?
- gsalas
Confirming 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.