Forum Discussion

ADevgun's avatar
ADevgun
Frequent Visitor
3 years ago

MySQL Timeout OLE DB or OBDC error

I am new to power bi and wanted to bring in data from a mysql server but it keeps timing out.   OLE DB or OBDC error: timeout expired. the timeout period elapsed prior to completion of the operatio...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ADevgun ,

Please try below ways:

1. Please try to do data cleaning in MySql Server side, filter some unuseful data firstly

2. Please try to optimize your MySql table, it will speed up the query efficiency

3. In Power BI, Use measure as much as possible and avoid using calculated column, also could try to optimize the dax 

4. In Power BI Service, bacause your data is too many, if you want to refresh many data by once, please try incremental refresh, it will reduce the refresh time when you refresh the dataset secondly.(Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn)

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.