Forum Discussion

sami19740118's avatar
sami19740118
New Member
9 years ago

my SQL data source "null" error

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,

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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