Forum Discussion

Swapneel's avatar
Swapneel
Advocate I
9 years ago
Solved

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....
  • mllopis's avatar
    mllopis
    9 years ago

    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.

arify's avatar
arify
Microsoft Employee
9 years ago

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's avatar
    Swapneel
    Advocate I
    9 years ago

    Thanks so much arify.

     

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

     

    Have emailed you the traces folder.

     

    Thanks again.

     

    Swapneel

    • arify's avatar
      arify
      Microsoft Employee
      9 years ago

      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's avatar
        Swapneel
        Advocate I
        9 years ago

        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.)

         

         

        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