Complex data from txt file into power query - help requested

Power Query
1

Hi ,

I need to create PBI file using data from attached .txt achieve this view below :

image
image962×393 126 KB

sample - dui .txt (600 Bytes)

It should look like below in Power Query :

image
image1667×101 3.7 KB

DUI - example.csv - I created to show how it should look like in PBI
Lines starting with “V” are crossed off and I don’t need them.

DUI - example .csv (1.4 KB)

Could you please help me to find appropriate and correct steps ( M code)to complete this task. My original is made up of millions of paragraphs like 3 ones above in screenshot.
Many thanks in advance - Iwona

2

FYI, Power BI has a limited amount of rows it can show. I tried before running a SQL query and it would always time out because it was more than 1 million rows. Solved: how many rows can power bi handle - Microsoft Power BI Community.&text=For%20Import%2C%20there%20is%20no,import%20into%20Power%20BI%20currently.)

3

@Iwona

Try this

image
image1693×293 14.7 KB

sample - dui.pbix (93.7 KB)

1 Like
4

@lbarron20

That is for DAX Queries and not for Power Query Transformations.

1 Like
6

@Rajesh Your solution ( M code in Power Query) is simply perfect for my need and works for every single row of my original TXT file ( 12677 rows) and they all appeared as table in PBI .

So grateful for your time and support in this matter.

Regards ,

Iwona

1 Like