3016761 - Only 500 rows data can be displayed in tables in embedded SAC story

Only 500 rows data can be displayed in tables in embedded SAC story even if the data source contains more data rows.

• Embedded usage of SAP Analytics Cloud.

1. Create a story using Embedded Analytics.
2. Export the data to excel, the data has only 500 rows no matter what date filter is set.
3. Check the data source has more than 500 rows. 

To have decent performance for initial data queries, the result is limited to 500 rows by 60 columns.

• You can choose to either change the filters to return fewer results or edit the drill limits and retrieve more data.
• To edit the drill limit, ckick "Edit Drill limitation" from the warning popup
  
  
  Select 'Custom' and adjust the drill settings according and click 'OK'
  
  
  
• More information can be found in the following user's guide page: Use Tables to Visualize Data

• How to find User Assistance for SAP Analytics Cloud?
• Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

Your feedback is important to help us improve our knowledge base.

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, excel, embedded, S4, HANA,  S/4HANA, excel, CSV, rows, row, number, limit, limitation, max , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem