Cannot See All Views when i connect to MySQL

[awnibond]

Hi, 

i am trying to connect to MySQL 8 Database, but for some reason i cannot see all views that i have available in my Database, but i can see only two of them! 

how can i fix this behaviour ??  

i saw a very old subject here in the community but it didnt help me at all, and i suppose that this kind of issue should be fixed by now 

Looking forward to hearing from you 

[Anonymous]

@awnibond 

I am working with MySQL as well and did not encounter this issue.

Did you try the advanced mode? Try to query the view(s) and see if they are recognised.

Thanks

A

[awnibond]

Very Strange, Yes i tried the advanced mode, but the view was not recognized as well 

the strange thing is that i can find 2 views available out of 9 which is really strange.

what is your MySQL connector that you are using ? 

[Anonymous]

@awnibond 

hats My environment setting -->

Thanks!
A

[awnibond]

@Anonymous  thank you very much for your input

i have  uninstalled my connector, and installed the same version that you have, but unfortunatly i still have the same issue, see the screenshot below, in the right side is workbench, on the left side i have Power BI 

What could be the issue? 

[Anonymous]

I'm having the same isuue, did you found a solution ?

thanks

[Anonymous]

Hey @awnibond 

Not sure whats wrong with your environment. I would advise to open a support call with MS.

Meanwhile, try changing to the server name or localhost, in the connection string. If possible of course.

I see more than 2 views and never had such an issue before.