Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am trying to "enter data" in powerBI that is a large table. I am doing this to avoid a connection and avoid refreshing data. I can copy the data from a csv file but when i paste into enter data i get an error with 3000 cell limit.
I then came across this tip to bypass: https://www.reddit.com/r/PowerBI/comments/mw9qji/bypassing_power_queries_enter_data_3000_row_limit/
But I am unable to follow the instructions and its not very clear. Can someone enlighten me on if this would actually bypass the 3000 cell limit? If so, can you provide better instructions?
Thanks!
Solved! Go to Solution.
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 know this is an old post but for me everything is grayed out and I do not have the option to follow steps 5+
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!