Power BI Challenges with JSON, XML, and Yes/No Data

  • Jeffrey M. Rhodes


Adding in multiple answers, multiple lines of text, and Yes/No responses leads to some additional challenges. For example, we did an IT Demographic Survey of all our academic personnel at the Air Force Academy. I used the same technique as the previous chapter to copy each response to a SharePoint list using Microsoft Flow. We see the first inkling of an issue when we look at the data in SharePoint as shown in Figure 67. The extra explanatory text after Level 4 gets copied (since it was part of the answer). More significantly, the multiple answers get represented as ["EDU (wired)","MIL"]. Those with some web programming experience might recognize this as JavaScript Object Notation. When we connect to the data in Power BI, we see an additional issue in that the data is displayed as HTML as shown in Figure 68.

Copyright information

© Jeffrey M. Rhodes 2019

Authors and Affiliations

  • Jeffrey M. Rhodes
    • 1
  1. 1.ColoradoUSA

Personalised recommendations