my SQL data source "null" error

[sami19740118]

Hi, this is the first post in this forum for me.

I downloaded Power BI desktop on my PC and connected successfully to my mySQL on the server.

However when I tried to bring the data into my desktop, PowerBI pops up the message "Null objects must have values" (I am using Power BI in Japanese, so this message is my translation from JA to EN..).

There are also some system related messages such as,

- Microsoft.Mashup.Evaluator.Interface.ErrorException:

- System.InvalidOperationException:

-Microsoft.Mashup.Engine1.Library.Common.QueryResultTableTypeValue.get_TableKeys()

All tables of mySQL I tried to import to PowerBI do not permit Null.

I was wondering why  PowerBI pops up these messages.

mySQL version is 5.5.38.

If someone can help, I appreciate.

Best regards,

[Anonymous]

@sami19740118,

I am not able to reproduce your issue when I import a MySQL table which contains null data into the latest version of Power BI Desktop(2.46.4732.721). Could you please share me structure and sample data of your table so that I can re-create your table in my environment?

Regards,
Lydia