Step 1: Go to home → click on get data → select Analysis Services Step 2: Connection window looks like bellow Provide server name. Select required database in list In fields panels, showing list of table in database Relationship between tables looks like bellow Step 3: Drag and drop table Select required fields to table