Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data loading from Azure SQL Server failing

Hi,   I am trying to load data from my Azure SQL Server DB, and the there are millions of rows to load.  It starts loading and until few thousand records it works fine, then suddenly fails.  Few ti...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

I'd say there was an error on one of the steps, perhaps it wasn't shown on the query editor, (you'd need to refresh in every single step), and there's also the possibility that some data that wasn't being loaded in the query editor was causing the error. Data size or something else also may cause the problem.

 

For further information, you may refer to the following links.

https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with-direct-connect

https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/m-p/116683

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DataSource-Error/m-p/865494

 

Best Regards

Allan

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.