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

      • mllopis's avatar
        mllopis
        Community Admin
        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.