cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Swapneel
New Member

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
Microsoft
Microsoft

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
Microsoft
Microsoft

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
New Member

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

Microsoft
Microsoft

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
New Member

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

Microsoft
Microsoft

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
New Member

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

Thanks @mllopis . Will do.

Microsoft
Microsoft

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
New Member

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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

Top Solution Authors
Top Kudoed Authors