Power Query Tally Connector

[admin]

Use the Below Syntax for the Power Query Tally Connector

Code: Select all

let
    Source = Odbc.Query("dsn=TallyODBC64_9000", "<<<<<<<<<<<Enter Your Sql Query Here>>>>>>>>>>>>>>")
in
    Source

Code: Select all

let
    Source = Odbc.Query("dsn=TallyODBC64_9000", "Select $Name, $_primaryGroup, $Parent, $openingBalance, $$AsCramt:$_ClosingBalance from Ledger")
in
    Source

Video Guide

https://www.youtube.com/watch?v=NCa3SywyMUE