Forum Discussion

agarcialoz's avatar
agarcialoz
Frequent Visitor
3 years ago

transform json and i cant expand colums

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)

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • agarcialoz's avatar
    agarcialoz
    Frequent Visitor
    3 years ago

    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!