Xcelsius dashboard based on sap netweaver BW connection

Hi,

I am facing some data formatting issue in xcelsius.

xcelsius is using bex queries. the issue is that before making any formatting change , i need to see the data in spreadsheet available in xcelsius.

but spread sheet is blank and i am not sure how to refresh it to bring the data in excel.

I tried to data connection and preview data but it gives me message " xcelsius cannot connect to BI query beacuase of IO connection fault. make sure url and connection is good"I am bit new to xcelsius and bex query.

Could you please help me.Thansk in advance.

Thanks,

Anamika