© Jeffrey M. Rhodes 2019
J. 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

Jeffrey M. Rhodes1 
(1)
Colorado, CO, USA
 
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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.