I want to import Sales register into Powerquery from Tally not from excel file

[Kalpesh60]

I want to import Sales register into Powerquery from Tally not from excel file

[v-priyankata]

Hi @Kalpesh60 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@Olufemi7 @BA_Pete @cengizhanarslan Thanks for the inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @Kalpesh60 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[cengizhanarslan]

You cannot connect Power Query directly to Tally as a native connector (there is no built-in “Tally connector” in Power BI / Power Query). However, you can import the Sales Register without using Excel as an intermediate file, using one of the supported integration methods below.

• Enable ODBC in Tally:

  • Tally → Gateway of Tally

  • Enable ODBC Server

  • Note the Port (default is 9000)

• In Power BI / Power Query:

  • Get Data → ODBC

  • Choose Tally ODBC Driver

  • Select the required tables (Sales, Vouchers, Ledger, etc.)

[BA_Pete]

Hi @Kalpesh60 ,

I think you have a few options. They're all fairly detailed, so please forgive the link drops:

ODBC or EasyReports 

CData Connector 

Pete

[Olufemi7]

Hi @Kalpesh60, 

Microsoft doesn’t provide Tally‑specific documentation. However, Tally supports ODBC, and Power Query can connect to any ODBC source.

The official Microsoft documentation for the ODBC connector is here: Power Query ODBC connector –ODBC 

To import the Sales Register:

1. In Tally, go to Gateway of Tally → F12 → Advanced Configuration → Enable ODBC.

2. Keep Tally running.

3. In Power Query, choose Get Data → ODBC and select the Tally ODBC driver.

4. Run a query such as:
   

SELECT * FROM Vouchers WHERE VoucherTypeName = 'Sales'

1. This will bring the Sales Register directly into Power Query without exporting to Excel.

Note: Microsoft documents the ODBC connector itself, but for Tally‑specific ODBC setup you’ll need to refer to Tally’s own documentation or community guides.