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.
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.
Solved! Go to Solution.
The NaN in the JSON did the trick. Everything is awesome now 😄
The NaN in the JSON did the trick. Everything is awesome now 😄
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |