Forum Discussion
Helper ITally Data Linked to Powerbi
The tally data is linked with the powerbi through SQL
The end result is to Construct the Financials statment in powerbi with drill down view for further analysis.
Mainly the data I accumulated from the SQL Tally data is :
Ledger Master, Group Master, trn_accounting (amount), trn_voucher (date)
But the end result of groupwise drill down till ledger is not fetching correct amount . Some directly fetch correct but some are having wrong grouping & amount . The relationships are build in hierarchy level .No extra table of mapping is used . Any suggestion would be grateful.
Hi Rahp ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Akash_Varuna Thank you for your quick response.
Alongside the solution provided by Aksash_Varuna, you may also consider trying the following:
As you're trying to build a financial statement in Power BI using Tally data (Ledger Master, Group Master, Transactions), but the group-wise drill-down amounts are incorrect.
- Please ensure that,Group Master has proper parent-child hierarchy (e.g., GroupID, ParentGroupID) and validate that ledgers are correctly mapped to their groups.
- Use explicit relationships between Ledger Master, Group Master, and trn_accounting.
- Sometimes auto detected relationships might be wrong, please avoid relying on auto detected ones.
- Build a hierarchy (Group → Subgroup → Ledger) using DAX or Power BI visuals.
- Ensure you're aggregating at the ledger level only and also avoid including summary data from group levels.
- Please make sure that cross-filtering is working as expected from group to ledger to transactions.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
5 Replies
Hi Rahp ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Akash_Varuna Thank you for your quick response.
Alongside the solution provided by Aksash_Varuna, you may also consider trying the following:
As you're trying to build a financial statement in Power BI using Tally data (Ledger Master, Group Master, Transactions), but the group-wise drill-down amounts are incorrect.
- Please ensure that,Group Master has proper parent-child hierarchy (e.g., GroupID, ParentGroupID) and validate that ledgers are correctly mapped to their groups.
- Use explicit relationships between Ledger Master, Group Master, and trn_accounting.
- Sometimes auto detected relationships might be wrong, please avoid relying on auto detected ones.
- Build a hierarchy (Group → Subgroup → Ledger) using DAX or Power BI visuals.
- Ensure you're aggregating at the ledger level only and also avoid including summary data from group levels.
- Please make sure that cross-filtering is working as expected from group to ledger to transactions.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hi Rahp ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Please don't forget to give a "Kudos " – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hi Rahp ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Please don't forget to give a "Kudos " – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
- Akash_Varuna
Super User
Hi Rahp Check that the connections between Ledger Master, Group Master, trn_accounting, and trn_voucher match your drill-down structure. Make sure the drill-down logic in Power BI is set up correctly for accurate grouping. Double-check the calculations and totals to see if they’re filtering the data as expected. If it still doesn’t work, try adding a mapping table or fixing the connections manually.
