Grouping tables in Power BI is a powerful modeling technique that allows you to select from overlapping groups either in a slicer or across a matrix. Useful for scenarios where say, you have several ad campaigns going on and an individual product can be a part or more than one campaign. Traditional calculated columns or Snowflake tables produce ugly and unpleasant user experiences while grouping tables give end users exactly the behavior they were hoping for. In this video Brian Grant will walk you through what they are and how you can build your own. Since these do usually utilize bi-directional relationships he will also walk you through some things to watch out for when adding these.
Connecting Power BI to QuickBooks isn’t exactly plug-and-play. Using ODBC drivers is complex but doable. Here are a few tips and a list of top ODBC connectors.