1 of 9

ECBC

2 of 9

3 of 9

Read Table...

by Choosing the Parameters

4 of 9

Step 1: Filling up the Data Source. �Data Tab...to Get Data...From Web and provide the web link

5 of 9

Step 2: Filling up the Data Source-Choosing the relevant table

6 of 9

Step 3: Promoting Headers

7 of 9

Step 3: Promoting Headers

8 of 9

Step 3: Changed Data Type (Automatically Detected by PQ and done)

9 of 9

Examine Each query steps- No Code is ever written all through

  • By Now You must have got the pattern...
  • Open the Excel Solution ...open the query option and examine each step.

Your text here