JSON Data issue

Hi Team,

While importing JSON file in powerbi only 1st 100 rows are showing, but available rows are 2400.

how can display remaining rows ??

Thanks

1 REPLY 1

Have you tried "save and exit" on the Power Query editor and then taking a count using a card visual.

Helpful resources

Announcements

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

Check out the October 2025 Power BI update to learn about new features.

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.