Get Vendor Ledger Entries for all the companies in Sandbox using AL DataSet

Hi all,

I am new to Dynamics 365 Business Central Cloud. I have to create a report using AL, in which i have to get Vendor Ledger Entries of all the companies in Sandbox and create report in  RDL. So far i was able to achieve this in Power BI where i connected to my sandbox and got Vendor Ledger Entries for each Company and merged them to show on single company(consolidated) but in VSC and AL i am unable to do so.

Please point to right direction