Data Merging

In this exercise, you will create a Dataflow that loads two tables related to a snowflake dimension, and use the Power Query interface to merge the two tables into a single table suitable for a star schema.

Table	Description	Columns	Example
ds-snowfood-menu-categories	Contains menu categories	menu_category_id, category	1, American
ds-snowfood-menu-items	Contains menu items	menu_item_id, item_name, menu_category_id, price	101 , Hamburger , 1 , 12.95

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 horizontal menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.