Multivalued Dimensions and Bridge Tables
Multivalued dimensions are required to model some scenarios. In this example scenario, a restaurant chain has a roster of managers so that multiple managers can be assigned to a restaurant. In this exercise, you'll build a bridge table to model the many-to-many relationship between restaurants and managers.
Note: If you get an error about an API rate limit, this usually happens because a previous Fabric task has not completed. You can view active Fabric tasks from the Monitor page (located on the left vertical menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.
This exercise is part of the course
Transform and Analyze Data with Microsoft Fabric
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
