Cannot See All Views when i connect to MySQL

Question

Hi,&nbsp;&nbsp;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!&nbsp;&nbsp;how can i fix this behaviour ??&nbsp;&nbsp;&nbsp;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&nbsp;&nbsp;Looking forward to hearing from you&nbsp;&nbsp;&nbsp;

anonymous · Answer

awnibond&nbsp;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.&nbsp;ThanksA&nbsp;

awnibond · Answer

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 · Answer

awnibond&nbsp;hats My environment setting --&gt;&nbsp;&nbsp;Thanks!A

awnibond · Answer

Anonymous&nbsp; thank you very much for your inputi have&nbsp; 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&nbsp;&nbsp;What could be the issue?&nbsp;

anonymous · Answer

Hey&nbsp;awnibond&nbsp;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.

Forum Discussion

Cannot See All Views when i connect to MySQL

6 Replies

Related content

Understanding Lineage View

Viewing/Editing of SQL Views

View Items that depend on a Connection

TMDL View

Connection failed using a Folder connection in a pipeline