Get Data

1. First click Get Data or Excel logo.

2. Then select excel.

3. Find local storage where we store the dataset.

   

4. The navigator will pop out then we can select the display table.

   Here we will just use Table 1 (Sheet1)

   

   Then we can tick the box and click ‘load’.

5. How to know whether our dataset has been loaded?

   

   • Check the report on the very top left side.
   • Then check the very right side where it is written ‘Table 1 (Sheet1)’.

Direct Query