TypeError: Converting circular structure to JSON

Question

Hi SyncFusion Support,I am trying to use Pivot Grid - OLAP https://ej2.syncfusion.com/react/demos/#/material/pivot-table/olapthen I change the dataSourceSetting to the data I created in Firebase and its a json data. But I always get this "Converting circular structure to JSON" error.Is there a way to access the content of this https://bi.syncfusion.com/olap/msmdpump.dll so that I could re-create it?

Saranya Sivan · Accepted Answer

Hi JB Ochinang, 
  
Thanks for contacting Syncfusion Support.    
  
Kindly check the below blogs to check the permission to access the cube from client application, 
  
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/grant-cube-or-model-permissions-analysis-services 
  
https://docs.microsoft.com/en-us/sql/analysis-services/instances/connect-from-client-applications-analysis-services   
  &shy; 
To check the connection in Excel, please follow the below steps,   
  
  
   
  
Provide the connection details,   
  
  
   
  
Select the cube from appropriate database,   
  
  
   
  
Note: If you found any issue while connecting cube in excel. Run the excel application as administrator. 
 
You can also download the Adventure works sample database from the following link. 
 
https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms 
  
Please let us know if you need further assistance on this.  
  
Regards, 
Saranya Sivan.