Forum Discussion

parulagarwal's avatar
parulagarwal
Frequent Visitor
8 years ago
Solved

Pivot unpivoted columns

Hi,

 

I imported data from excel, unpivoted few columns and used the result to create multiple visuals in Power BI.
Now I want to use the original (pivoted) version of the dataset for creating a GANTT Chart.
How can I do that?
1. I want to have 2 copies of the same source data – 1 pivoted and the other unpivoted.
2. Even if I import the dataset again (in pivoted form) , will this automatically update/refresh the unpivoted dataset as well?
3. Is it possible to create a duplicate of existing dataset without having to import data from excel again?

Thank You,
Parul

Need Help
  • ImkeF's avatar
    ImkeF
    8 years ago

    You can split up your exsiting query into 2 like this:

    so you can create your GANTT-chart based on the pivoted data (first query) and the second query that will be created will reference this first one. So with any luck only the first query will fetch the data from Excel (once).

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    You can duplicate a query in the Power Query window.  Then just delete all the steps in the Applied steps window.

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    8 years ago

    You can split up your exsiting query into 2 like this:

    so you can create your GANTT-chart based on the pivoted data (first query) and the second query that will be created will reference this first one. So with any luck only the first query will fetch the data from Excel (once).