Hi,
I am trying to create a report in Power Bi with data from BC:
I was previously using the Web Service G/L Entry table in Power BI with Dimension Codes and Dimension Value tables to get dimension names. However, due to performance issues and excessive data loading, I optimized my approach by creating an API query.
Instead of using multiple dimension fields, I now retrieve only Dimension Set ID and link it with the Dimension Set Entry table to get dimension details. While this has significantly improved refresh performance, I’ve noticed that dimension values no longer match the actual G/L amounts for those dimensions in Business Central.
I suspect this could be due to dimension corrections made by users, but I’m unsure if this is the expected behavior.
Could dimension corrections cause such discrepancies, or am I missing something?
Any insights would be greatly appreciated!
