Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community,
I am using source file as the below one:
However, my organization is making changes constantly, and starting today i have 2 more columns, which i don't want to see at all. As you can imagine my whole data model suffers because of this change. Can someone help me keep my original structure of the report? Below are the new ones:
Thank you!
Atanas
Solved! Go to Solution.
Hi @Anonymous ,
click on the first step of your query with your mouse and do the selection.
This will automatically insert a step for you.
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
Hi
The other workaround within PowerBI is, In PowerQuery Editor do the following steps.
1. Do the unpivot transformation to get all the groups into one column
2. Split using delimiter then regroup using first & last value as per your exiting group logic
3. Pivot it back.
Thanks
Venkata Nalla
Hi @Anonymous ,
as the first step before all other transformations:
This will keep your column names clean and managable.
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
thank you, but how do i put that in context? I already applied many steps to transform my data (with the old structure). Should i apply that as an additional step?
thank you,
Atanas
Hi @Anonymous ,
click on the first step of your query with your mouse and do the selection.
This will automatically insert a step for you.
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
Dear Imke,
It worked like a charm! Just one adjustment on my end. It worked pretty well after the "promoted headers" step!
I don't experience the referesh problem anymore. Thank you for this information!!!
Thank you for your quick reply and adding Imke to to the discussion!
One last thing. Here's a link to a webinar hosted by Chriss Webb: https://www.youtube.com/watch?v=mGnNn6gnrKk
It focuses on pretty same problems. Hope it will help you as well.
Stay safe!
Atanas
Hi
The other workaround within PowerBI is, In PowerQuery Editor do the following steps.
1. Do the unpivot transformation to get all the groups into one column
2. Split using delimiter then regroup as per your exiting logic
3. Pivot it back.
Thanks
Venkata Nalla
@Anonymous , The best way is to keep the data model stable or add columns at the end. In this way, I do not think you can avoid changes to data model.
@ImkeF , Any suggestions on this
Thank you Sir!
I do realize that, but no one asked me when they submitted the request to IT...
I would really appreciate any help...
Atanas
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |