Microsoft Office Tutorials and References
In Depth Information
At this point, when you click Next you see exactly the same request as in Figure 5-40 because
you are at the same point: you just selected a report, and now you have to select the tables
to import from that report.
In Figure 5-44, you saw the selection of the same report previously used in Figure 5-36.
However, you should note that the URL is a little bit different. In fact, the URL for the
report shown in the browser was
Now, the URL to load data from a report in PowerPivot is different:
The difference is that the URL used by PowerPivot is a direct pointer to the report, which
bypasses the user interface of Report Manager that you used earlier. You should ask for
the assistance of your IT department to get the right URL for your reports.
As a rule of thumb, if you can “navigate” in the reports available through a browser by
you can do the same by using the name ReportServer in place of Reports when you
want to navigate into available reports by using the Open Report dialog box:
The SERVERNAME and INSTANCENAME parts of the path need to be replaced by the real
names used on your server. In our examples, Reports is the SERVERNAME and K8R2 is the
INSTANCENAME. In case the INSTANCENAME is omitted, the underscore character also
has to be eliminated. You can deduce SERVERNAME and INSTANCENAME by looking at
the URL for the reports in your company.
However, if the URL used for your reports has a different nomenclature and is actually
a SharePoint path, you should be able to use the same URL both in the browser and in
the Open Report dialog box you saw in Figure 5-44.