Forum Discussion
OLE DB or ODBC error
Hello all, Does anyone what the below error is and how to fix it? Thank you in advance, Minas
Hi Anonymous
Is it direct query or imported?
How big is your data source?
If you connect to My SQL using Odbc connector, it is important to know the data size limitations.
If you have large data, you could try some workarounds:
https://community.powerbi.com/t5/Desktop/Get-Limited-data-in-Power-BI/td-p/298260
https://blog.crossjoin.co.uk/2019/01/04/odbc-power-bi-power-query-refresh-performance/
https://docs.microsoft.com/en-us/power-query/odbc%C2%A0
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.