OLE DB or ODBC error

[Anonymous]

Hello all,

Does anyone what the below error is and how to fix it?

Thank you in advance,

Minas

[v-juanli-msft]

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

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.