transform json and i cant expand colums

[agarcialoz]

Hi all!

In the powerquery editor, in the column that is in json format I click transform json and when I want expand the colums the following message appears:

"the limit of 1000 digital rows has been reached"

(That column is new in DB so many of the first rows do not contain anything and appear empty)

[agarcialoz]

Hi Stephen, thanks for reply

But as you can see in the image it says that no columns are found. So I can't expand them.

Regards!

[Anonymous]

Hi @agarcialoz ,

It's just the limitation, the data will be all in the data model.

About transforming JSON, you could refer to

Json Transformations - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.