Hi,

My team at my company would like to display data from multiple local MS Access databases and from a MS Form in our PBI App. We have successfully worked with our IT department to setup gateways for the Access databases, but we're running into issues because we want to create data relationships between these 3 data sets (i.e. we want to relate tables using shared IDs, not just display data from multiple sources in one dashboard).

My solution to this is to link all data in one MS Access database, then create a gateway from that db to our App's workspace. While this may work, it feels like there might be a better solution, because this requires linking MS Forms data to a local Access file, then re-linking that data to PBI Service.

Does anyone know if there is a more elegant way to link/combine datasets within a PBI workspace?

Thanks,
Charles