Forum Discussion
Source File Columns I Don't Want In My Data Model
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
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.
8 Replies
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
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
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:
- Check the column you want to keep
- Righclick the mouse
- Click: Remove other columns
This will keep your column names clean and managable.
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
