Forum Discussion
Reorganized datas from a flat cube
AFAIK There is no way to do it. Power Query certianly cannot. You might be able to script it on Tabular Editor, but that would require you to enable unsupported functions, and any issues (even if possible) will not be supported by MS. They don't support T/E editing M and creating objects.
We need data, and a good mockup of expected results. I'm not typing in all of that data in the image.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
OK, sorry, that was my first post.
The goal is to transform the "Line items" column into tables containing the others fields (following screenshots)
The source :
What I need:
The first disctinct value (in the black rectangle) becomes the name of a new table containing datas of the red rectangle.
Then next distinct value, until the end.
With the datas below, I should have a bit less than 20 tables at the end.
The result with the first value of Line Items Column:
To complete, here are some datas.
VersionsLine ItemsTimeACTIVITE COMMERCIALE- Détails- Bloc
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
I think it's better to find the solution now.
Thanks to all.
Ludo
Are you wanting Power Query to create those tables? It cannot. Power Query cannot create other objectes (lists, tables, values, etc) - it can only manipulate the data it has. It can convert the existing data into a table, list, or whatever, but it cannot create other objects on that side pane.
If that isn't what you mean, please advise.Hi Edhans,
I want new tables based on the source "Run Export Action", maybe another way exists to do it, but I want to do it with Power BI.
In fact I want to split "Run Export Action" to obtain many tables to resume, it doesn't matter how, but with Power BI.
Regards,
Ludo
AFAIK There is no way to do it. Power Query certianly cannot. You might be able to script it on Tabular Editor, but that would require you to enable unsupported functions, and any issues (even if possible) will not be supported by MS. They don't support T/E editing M and creating objects.