Forum Discussion
How to bypass 3000 cells limit?
1. Import your csv into PQ
2. Insert a new step in this table
= Text.From( Binary.Compress( Binary.FromText( Text.From( Json.FromValue( Source ) ), BinaryEncoding.Base64 ), Compression.GZip ) )3. Insert a new blank Query by right clicking the left pane
Put following formula
= Json.Document( Text.FromBinary( Binary.Decompress( Binary.FromText( "MASSIVE_WALL_OF_TEXT_GOES_HERE" ), Compression.GZip ) ) )4. Copy the output of step2 and paste into MASSIVE_WALL_OF_TEXT_GOES_HERE in above query
5. Click To Table under Transform
6. Click double edged arrow and extract all fields
I have prepared one sample on the basis of this and uploaded whch will help you to understand to https://1drv.ms/x/s!Akd5y6ruJhvhuXwZMrH7laaLcVFj?e=ie2m5d
1. Import your csv into PQ
2. Insert a new step in this table
= Text.From( Binary.Compress( Binary.FromText( Text.From( Json.FromValue( Source ) ), BinaryEncoding.Base64 ), Compression.GZip ) )3. Insert a new blank Query by right clicking the left pane
Put following formula
= Json.Document( Text.FromBinary( Binary.Decompress( Binary.FromText( "MASSIVE_WALL_OF_TEXT_GOES_HERE" ), Compression.GZip ) ) )4. Copy the output of step2 and paste into MASSIVE_WALL_OF_TEXT_GOES_HERE in above query
5. Click To Table under Transform
6. Click double edged arrow and extract all fields
I have prepared one sample on the basis of this and uploaded whch will help you to understand to https://1drv.ms/x/s!Akd5y6ruJhvhuXwZMrH7laaLcVFj?e=ie2m5d
- I am very new to Power M. I've tried to follow these steps and was successful in doing steps 1-4. For step 5, I included your code as Source in Applied Steps with my step 2 massive wall between " copy/paste". I got the result as a List (1 column and it has "Records" that I can click to show the result in a separate view). Under Transform tab everything is greyed out though, and I can't convert the data to table.
right click on the list column -> To table
This works but man, it ain't pretty.
