...
- Open an Excel workbook
- Go to Home ribbon| Get data | Web dropdown
- Choose From Other Sources | From Web
- Paste the URL into the From Web box. Click OK.
- Note: Some Projector report fields, such as rates and margin, are not included in the CSV output. The reason is that they can be calculated from other fields in the report. If you want all calculated fields included in the report output, add the following flag to your URL string:
- ExplicitFieldsOnly=yes
- ExplicitFieldsOnly=yes
- Note: Some Projector report fields, such as rates and margin, are not included in the CSV output. The reason is that they can be calculated from other fields in the report. If you want all calculated fields included in the report output, add the following flag to your URL string:
- Your data will preview in a popup window. Click Transform Data.
- The Transform editor will be displayed. Click the gear icon for Source under Applied Steps.
Set Line Breaks to Ignore quoted line breaks and click OK
Tip Why this step? Projector encloses any text field in double quotes. When that quoted field contains line breaks, we need Excel to treat it as a single entry and not try to create a new row of data.
- Optionally modify the table name under Properties
- Click Close and Apply to load the table to your data model.
...