Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiple Data Sets Connect

Hi all,

 

I am working on a team and we are all working on different projects. Currently, we have a few different data models/sets as shown in the attached picture. 

 

There is an Employee ID column across all the datasets so we are hoping to join it all based on the Employee ID and build dashboards involving all aspects. Is this possible to bring together all the datasets and join on a single field? If so, how?

 

Also, if we talk about key fields we need from each dataset is there a way to remove all other fields so that when we do connect it all together we don't have an overwhelming amount of data.

 

Any insight would be appreciated! Thank you all!

Need Help
Tutorial Requests

4 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    Hi Anonymous ，

    In Power Bi service, you can create multi reports by the same dataset, However you cannot create one report by using different dataset. One way to work around, creating dashboard could combine different visuals from different reports. Also you can connect to all the data sources of different datasets and import the data by Power BI desktop, then you can use all the data.

    refer:https://www.youtube.com/watch?v=oX4RDyMOhIw

     

     

     

    Best Regards

    Lucien

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    Hi Anonymous ，

    Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

    Best Regards
    Lucien

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ok. I need to be able to use at least 1-2 filters though once I pin items on the dashboard. Maybe not possible with what I'm trying to do then.

     

    Thank you for your response!

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    Hi Anonymous ，

    Unfortunately, for now, even if you fix the entire report page containing the slicer to the dashboard by selecting "Pin Live Page", you can only filter the tile, not the entire dashboard.

     

    Best Regards

    Lucien