© Jeffrey M. Rhodes 2019Jeffrey M. RhodesCreating Business Applications with Office 365https://doi.org/10.1007/978-1-4842-5331-1_12
12. Power BI Challenges with JSON, XML, and Yes/No Data
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, ...
Get Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.