Tell us what you think

We want to create the best possible experience for our learners. Your feedback helps us to improve the experience for everyone.

Building Queries based on Microsoft Excel

Objective

After completing this lesson, you will be able to use personal data providers as a data source

Use Microsoft Excel as Data Source

You can build queries on Excel files.

If you're working in the Web Client, make sure the Excel file you want to use as a data source is available in the SAP BI Platform Repository, in Google Drive, or in Microsoft OneDrive (including SharePoint Online). Only the Rich Client supports files stored locally.

The Data Source dialog box contains a category SAP BI Platform Repository, with Excel.

Microsoft Excel: See the text before and after the image for more details.

When you build a new query and the data source you use is an Excel file you have various options to browse the SAP BI Platform Repository such as Categories, Favorites, and so on.

In the Excel Data Provider dialog box, you may define the properties to interpret the Excel file.

Excel data provider: See text before image for more details.

The Query Panel which has got the same look no matter the data source you use, is displayed.

Query panel: See the text before and after the image for more details.

Select the objects to query or to use in filters. When your query is complete, click Run.

Document with Multiple Queries

ExerciseStart Exercise

Next lesson