SAP Knowledge Base Article - Public

2802781 - Data Source Showing No Results


You are previewing the data source XYZ (XYZ represents the name of the data source) and you see that it is not showing data. However, there should be data to be displayed in this data source.


SAP Cloud for Customer

Reproducing the Issue

  1. Go to Business Analytics Workcenter.
  2. Go to Design Data Sources View.
  3. Search for Data Source XYZ.
  4. Select the data source and click on Preview Button.
  5. In the data source preview screen, run the data source
  6. No results or only a few records are displayed on the data source when there should be more records displayed.


The option to Show Real Data is disabled in Business Configuration settings. Therefore the data sources under Business Analytics work center will not reflect real results.


In order to display real data in the data source preview, you should follow the below steps:

  1. Go the Business Configuration Workcenter.
  2. Go to Overview.
  3. Under Business Configuration Search, Search for Administrator Analytics.
  4. Under the Type Activity, click on the configuration element Administrator Analytics - Settings.
  5. Under the title Real Data Shown to Key User Instead of Generic Data, you will see a check box named Show Real Data.
  6. Check this box to display real data
  7. Save

See Also

For Business ByDesign: 2679556 - Data Source Preview is not supported in Business Analytics


No Data in Data Source; Empty Results; Empty Data Sources; Data Sources Records; Null Data Source; Incorrect Number of Records; No Records in Data Source; Cannot Preview Data Source; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Cloud for Customer add-ins all versions