Forum Discussion

udayadeven's avatar
udayadeven
Frequent Visitor
2 years ago
Solved

Using two Datasets in power BI

Hi Experts ,   I have two datasets having same fields from two lists .. first list having current month data and the second one is having historical data ..   How can we switch the datasets in th...
Need Help
  • timahenning2's avatar
    timahenning2
    2 years ago

    AD, the concept is the same for SharePoint Lists.

    1. Open Power Query and select the current SharePoint List table.  Choose Append Queries As New from the PQ menu bar.

     

     

    2. Select the tables like this to union the data in Power Query:

     

    3. Your Power BI model should look something like this:

     

     

    4. You can now view the current and historical data in your visualization by changing the way your filter the data.

     

     

     Tim

     

     

timahenning2's avatar
timahenning2
Helper II
2 years ago

Have you thought about combining (union) the datasets into one table?  Your report and measures would point to one table.  Using a slicer, filtered by a field like date, you could then display current or historical data.   

udayadeven's avatar
udayadeven
Frequent Visitor
2 years ago

Hi Timahenning ,

 

Thanks for your advice ,.. yes , i am trying to use the UNION . but I a quick concern on this .. In my first dataset having new columns and Messures created thro PowerBI , Do i need to have the same things in second Dataset .. I tried to create but cannot use the same Messure name .. 

 

pls advice ..

 

rgds

AD