In this example we’ll show how to create a real-time connected Excel Power View using XLReport queries provided with the XLReport sample project.

1.) Create a real-time connected Excel sheet

· Let’s select the “Sales by Country” Query.

image

· Double click the query object.

· Select “Excel Live Data”.

image

· The data will be inserted into Excel.

image

2.) Build the Excel Power View

· Select the data-range.

image

· Click the “Insert PowerView” button.

image

· Work with the Power View as usual.

image

 

3.) Refresh the XLReport Data

· To retrieve the most recent data click the “Refresh” button on the XLReport menu.

image

image

4.) Refresh the Power View

· Select the Power View, right click and select “Refresh Sheet”.

image

Now; you got your most recent data in Power View.

image