Forum Discussion

cbamf's avatar
cbamf
Frequent Visitor
5 years ago
Solved

Joining multiple data sources into a single data set in PBI Workspace

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...
Need Help
  • cbamf's avatar
    cbamf
    5 years ago

    Hi all,

    I resolved this by creating 2 gateways to the two different MS Access DBs, creating the necessary relationships between those data sources and any other data sources I needed in PBI Desktop, then Publishing that report to my PBI Workspace. The associated data set has become my master data set for all further development.

    Thanks for the help!