Forum Discussion
Namrata_Das_CLR
3 years agoFrequent Visitor
Pulling Big Data From MYSQL database
Hi, I have a large data table stored in Mysql database and while pulling the same i 'm getting query timeout error as IT admin has set query timeout for security reason which he can't change. ...
Idrissshatila
3 years agoSuper User
Hello Namrata_Das_CLR ,
Try to create views and get only the data needed so you could have less load.
If you want all the data, try using direct query https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Namrata_Das_CLR
3 years agoFrequent Visitor
Thanks Idrissshatila , as you are aware mysql database does not support direct query, is there any alternative way.