Error ODBC

[RichardBI]

Hi everyone, this is my first post 😊

Need your help with this issue.

We have datasets in our DW in MySQL, I am working a dashboard with the common data, sales, discounts, etc. Every table of sales has 3 million rows (by month), and I use a SQL QUERY to read only the data that we need. After that I do some transformations in Power Query, I work with every single sales tables so I join all of those to create the FACT_TABLE with all months. This report works well when we load data of 6 months, but when I add one month more to FACT_TABLE I have the following error:

It happens after load millions of rows. 

I don't know if this happen becasuse of the server, internet, query, SQL.

Please your help with that

[amitchandak · Accepted solution]

@RichardBI , In such cases, we increase the timeout(Under Advance of connection) and try to load fewer data on the Desktop and more in the Service

if needed refer video from Guyinacube

https://www.youtube.com/watch?v=qZOEDBedATA

[RichardBI]

Thanks @amitchandak I will try. I have a question, this issue happens because of the server capacity, I mean there are a lot of data that break the connection or something like that?