Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
parulagarwal
Frequent Visitor

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

1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

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

PBI_ExtractPrevious.jpg

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).

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

2 REPLIES 2
ImkeF
Super User
Super User

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

PBI_ExtractPrevious.jpg

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).

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Ashish_Mathur
Super User
Super User

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.