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 Gilbert,

    I have read through the provided link, and I am of the impression that this would only work for PBI Desktop. Do composite models or DirectQuery work in PBI Service?

    I am attempting to create reports on PBI Service with one-to-many data relationships between data sets located in my team's PBI workspace.

     

    Thanks,
    Charles

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      5 years ago

      Hi cbamf 

       

      It is correct that it will also work in the PBI Service, anything that works in PBI desktop will work in the PBI Service.

       

      You might have to create some data sources using the Gateway or online, but it will certainly work.