Forum Discussion
Error ODBC
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
Anonymous , 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
2 Replies
Anonymous , 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
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?