Tally ERP 9 Data Extraction Issue?

[Anmolgan]

We have Tally ERP 9 software installed on the system we have the 64 bit ODBC driver installed on the machine with tally software as well, now we have all the details as per dataset provided in the tally server, balance sheet, voucher, stock details all present in tally server, now we are not able to extract the tally dataset with all the information into the PowerBI model, we are seeing various tables there but there are no information provided in the tables, and only last purchase order informaton is present there and we are not sure why this is happeing, does anyone ever encountered the issue like this?

Are there any solutions to this using which we can load the data into the Tally Server?

[GSTBillingSoft]

I’ve seen similar issues when connecting Tally ERP 9 to Power BI via ODBC often only partial data (like the last purchase order) shows up. This can happen if Tally’s data exposure settings aren’t fully enabled or the ODBC driver is pulling limited fields. You could check if the ODBC port is fully open for all reports and that company data is unlocked for API queries.

If you’re looking for a simpler solution without these connectivity hassles, you can try Sleek Bill billing software, which makes it easy to export complete data into formats

[GSTBillingSoft]

I’ve seen similar issues when connecting Tally ERP 9 to Power BI via ODBC  often only partial data (like the last purchase order) shows up. This can happen if Tally’s data exposure settings aren’t fully enabled or the ODBC driver is pulling limited fields. You could check if the ODBC port is fully open for all reports and that company data is unlocked for API queries.

If you’re looking for a simpler solution without these connectivity hassles, you can try Sleek Bill billing software, which makes it easy to export complete data into easy formats.

[amitchandak · Accepted solution]

@Anmolgan , refer these

https://community.powerbi.com/t5/Desktop/Driver-Connector-in-power-bi-for-Tally-ERP-software/td-p/30...

https://help.tallysolutions.com/article/DeveloperReference/integration-capabilities/using_odbc_inter...

https://community.powerbi.com/t5/Power-Query/Power-BI-with-Tally-ERP-9/td-p/437517

https://help.tallysolutions.com/article/Tally.ERP9/Data_Management/DM_TE9_Outward_Connectivity.htm