How to deal with "NA"s when adding rows?

[EricForgy]

Hi everyone,

I'm really loving working with Power BI and now I'm writing a Power BI pakage for use with Julia on top of the Power BI REST API. I am able to get my token, create a dataset and add rows to tables in that dataset. So far so good.

However, now I am trying to reproduce an existing dataset that was created by importing it from Excel. The original Excel worksheet contained some cells with "NA"s and I'd like to reproduce this with the Power BI REST API. How can I insert "NA"s into a table?

My current JSON implementation looks like this

\"ColumnNameWithDoubleValue\": {} 

But this isn't working. Any suggestions?

Should I try 

\"ColumnNameWithDoubleValue\": NaN

? I'll go ahead and try that. Anything else?

Thank you.

[EricForgy · Accepted solution]

The NaN in the JSON did the trick. Everything is awesome now 😄