i just success to connect power bi to my Odoo sql database but when i get data with caracters like < or & it it goes wrong.
it get me
I have tested on my side, it works well.
You may try to update Power bi desktop to the latest version.
If you still have this issue, you'd better create a support ticket in Power BI Support to get further help.