Power BI Connector - Web by Example

Web by Example is a new feature update from Power BI. Here is the step by step illustration.

1. Get Data --> Web

2. Enter a proper URL --> OK; I have used rottentomatoes Example :

3. On "Access Web Content" Page --> Choose Authentication --> Connect

4. Wait while its "Connecting..." :)

5. On Navigator window Click "Add table using examples"

6. In Column1 first row start entering Names of movies as examples. Enter at least 2 names. Power BI will automatically populate the other movie names in Column1 based on the examples provided.

Similarly Enter % Likes for at least 1st 1 or 2 movies as example and the rest is detected automatically by Power BI.

Similarly in 3rd or more columns as per your choice...

Rename the columns.

7. Load the Custom Table

8. Start creating reports...

Please provide your valuable feedback on this blog in comment section. Thanks,

Paras Singh

19-Jan-2019