Forum Discussion
OLE DB or ADC error: [outsource.error] An error happened while reading data from the provider
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
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.
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
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.
