Forum Discussion
Connecting to a Msql DB
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 h...
kentyler
Solution Sage
Solution SageThe 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-key-length/
Thanks I'll check that out!
v-kelly-msftCommunity Support
Hi mike118 ,
Is your issue solved?If so,can you mark the reply as answered to close it?
Much appreciated.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!