(I replied to this thread in another topic: Add BAQ to existing RDL)
However, if Alan is staying on Single Tenant, then this is an excellent solution. If they are going public cloud, I’m pretty sure you cannot reach back into your ERP database from the SSRS servers. IIRC, I was only able to report on what was extracted. This prevents a security concern you brought up awhile ago.