Sparsely Populated SharePoint Complex Columns and Power BI
When we use SharePoint lists as data sources for Power BI, there are all sorts of tricks and gotchas. As with any rapidly evolving technology, some of the tricks we find on the InterWebs are helpful, some are out or date, and some are just plain wrong. Recently I ran into a confusing issue when…