Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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...
Help when you know. Ask when you don't!
Thanks I'll check that out!
Hi @mike118 ,
Is your issue solved?If so,can you mark the reply as answered to close it?
Much appreciated.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |