As a new Reporting Analyst working with D365 F&O for ghe first time, I am seeking guidance on Dynamics 365 Finance and Power BI reporting. I am struggling with the current data structure:
• Data from the datalake is dumped into SSMS in views, without any clean dimension or fact tables (no ETL process performed). I can also see these views in Azure synapse
• There is no data dictionary or available schema to understand the relationships between views.
• I need to create SQL scripts to generate transactions, trial balances, and other relevant tables from GeneralJournalAccountingEntry that joins other views (tables)- custrans, ledger, customer /vendor name, general journal entry etc, but I'm getting duplicates or not capturing some subledger transactions.
• Are there any resources out there or documentation to reference and understand the relationships between the views?
.
Any assistance or guidance from experienced professionals would be greatly appreciated! Additionally, if there are recommendations for external tools that can automate this process, please share.
Thanks in advance for your help!
