Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

J. M. RhodesCreating Business Applications with Microsoft 365https://doi.org/10.1007/978-1-4842-8823-8_13

13. Working with SharePoint Lookup Columns in Power BI

Jeffrey M. Rhodes¹  

(1)

Colorado Springs, CO, USA

 

Let’s continue our example from the last chapter by visualizing our data. It gives us a good opportunity to explore how we work with lookup columns, such as the Class lookup column in the Attendee list. In this chapter, we will connect to our two lists, transform our data, and then create rosters and other visualizations of our data. After selecting a desired event, users can then export an attendee list, if desired.

Connecting to Our Data Sources

As ...