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!

cbamf's avatar
cbamf
Frequent Visitor
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!