Importing data from Tally erp 9

Hello All,

I have been asked to develop a dashboard for my company. The data source for my dashboard is Tally ERP 9.The problem is I am not getting how to access this data into excel. I have tried MS Query but the imported data was not what I was expecting. Kindly help me resolve this problem.

Thank you.
Poornima