cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Swapneel Frequent Visitor
Frequent Visitor

Error Connecting To Tally (Accounting Software) using ODBC

Hi,

 

I work for an Indian non-profit Dasra I'm trying to connect PowerBI Desktop to Tally ERP 9 (a popular accounting software used in India) using ODBC, to help better analyze our financial data.

 

I'm getting the below error.

 

Unexpected error: Unable to cast object of type 'System.DBNull' to type 'System.String'.

My OS (Windows 10), Excel, and Tally ERP are all 64-bit.

 

This most likely seems to be an ODBC issue (and not PowerBI), so apologies for posting this here.

But I've tried finding a solution all over the internet and could not find one.

 

Has anyone experienced something similar?

 

Do let me know if you require more details on the error.

 

Swapneel

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team mllopis
Power BI Team

Re: Error Connecting To Tally (Accounting Software) using ODBC

Hi @Swapneel (and thanks @arify for your help!),

 

In the future, please use the Issues Forum for reporting bugs or issues like this one. Link: http://aka.ms/issues.powerbi.com

 

This Community Forum is aimed at allowing users to interact/share solutions or questions for how to achieve something with Power BI, rather than reporting specific bugs (we have a whole separate forum for that :))

 

Thanks,
M.

View solution in original post

8 REPLIES 8
arify Established Member
Established Member

Re: Error Connecting To Tally (Accounting Software) using ODBC

Hi Swapneel,

 

Looks like the ODBC driver is giving us a null value where we don't expect it.

  1. Can you make sure you're using the latest version?
  2. If you're using the latest version, can you please send us a frown with traces? (Enable tracing from Options > Diagnostics > Enable Tracing (Verbose) (also you can open the Traces folder from here), then reproduce the failure, then close the PBI Desktop. You can get the traces from Traces folder.)

 

Thanks

Swapneel Frequent Visitor
Frequent Visitor

Re: Error Connecting To Tally (Accounting Software) using ODBC

Thanks so much @arify.

 

I am using the latest versions of both PowerBI and Tally.

 

Have emailed you the traces folder.

 

Thanks again.

 

Swapneel

Highlighted
arify Established Member
Established Member

Re: Error Connecting To Tally (Accounting Software) using ODBC

Hi again,

 

I looked into the details you sent, looks like this ODBC driver is telling us that the table name is null. Does Tally have such tables? If not, this is a very big problem with this ODBC driver, and we can't do anything until they fix their bug.

Swapneel Frequent Visitor
Frequent Visitor

Re: Error Connecting To Tally (Accounting Software) using ODBC

Thanks again @arify.

 

No, Tally does not have a table named "Null".

 

Below is a screenshot of the tables it contains, which I was able to access via MS Excel > Data > From Other Sources > Data Connection Wizard.

 

(But Excel gives me the same error as PowerBI, when I try to connect via ODBC.)

 

Tally_Table_List.JPG

 

How do I explain the issue with the Tally ODBC driver? Can you help me put it into a few words?

I can then contact the Tally Customer Support and seek their help.

 

Thanks again.

 

Swapneel

Power BI Team mllopis
Power BI Team

Re: Error Connecting To Tally (Accounting Software) using ODBC

Hi @Swapneel (and thanks @arify for your help!),

 

In the future, please use the Issues Forum for reporting bugs or issues like this one. Link: http://aka.ms/issues.powerbi.com

 

This Community Forum is aimed at allowing users to interact/share solutions or questions for how to achieve something with Power BI, rather than reporting specific bugs (we have a whole separate forum for that :))

 

Thanks,
M.

View solution in original post

Swapneel Frequent Visitor
Frequent Visitor

Re: Error Connecting To Tally (Accounting Software) using ODBC

Thanks @mllopis . Will do.

arify Established Member
Established Member

Re: Error Connecting To Tally (Accounting Software) using ODBC

I only had one last thing to say, and I couldn't find any thread that was opened in the uservoice, so I may as well just reply here the last time 🙂

 

This looks like a bug in the ODBC driver, and it's too critical for us to work around. You should contact to whomever made this driver and tell them that "SQLTables call returns null for table names".

 

Thanks

ravikedia Frequent Visitor
Frequent Visitor

Re: Error Connecting To Tally (Accounting Software) using ODBC

Hi,

 

There is a ready connector available for Tally which can import all data from Tally at pre-defined interval. You may connect on contact@easyreports.in for further details.

 

Regards,

Ravi

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 326 members 3,288 guests
Please welcome our newest community members: