Connecting to a Msql DB

[mike118]

I have succeddfully connected to a Msql DB, but the primary keys in the Msql DB are not reflecting in PowerBi. In the Mysql DB they are shown as "BLOB" fields? Can I correct this in PowerBi or do I have to correct this in the Msql DB, and if so how?

[kentyler]

The problem is Mysql cannot determine the length of the Blob field, and so neither can power BI... which means it can't use it.

Here is a post that suggests way to fix the length of the field... if you do that in mysql then power bi might be able to "see" it.
https://techjourney.net/mysql-error-1170-42000-blobtext-column-used-in-key-specification-without-a-k...

[mike118]

Thanks I'll check that out!

[v-kelly-msft]

Hi @mike118 ,

Is your issue solved?If so,can you mark the reply as answered to close it?

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!