Search code examples
jsonpowerbipie-chart

How can we use JSON result to pie chart in PowerBI. How do i convert JSON to Table

I have below JSON result. I am trying to use this in Pie chart. I am using Power BI desktop application.

[
  {
    "STATUS": "aborted",
    "CNT": 3
  },
  {
    "STATUS": "error",
    "CNT": 2
  },
  {
    "STATUS": "finish",
    "CNT": 3
  },
  {
    "STATUS": "NotStarted",
    "CNT": 11
  },
  {
    "STATUS": "sleeping",
    "CNT": 8
  }
]
Solution

  • Answer can be achived by referring below links. Thanks for the help !

    https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

    https://www.dutchdatadude.com/loading-multiple-json-files-using-power-query/