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

     

     

udayadeven's avatar
udayadeven
Frequent Visitor
2 years ago

Hi timahenning ,

 

thanks for the advice .. I am using share Point Lists for this ..

 

rgds

AD

timahenning2's avatar
timahenning2
Helper II
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

 

 

  • udayadeven's avatar
    udayadeven
    Frequent Visitor
    2 years ago

    Thanks timahenning2  for your advice ..  I did it as you said .. its working as expected 

    rgds
     
     
    AD