Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Storing a long text in a cell

Hello,   I'm actually trying to store a long json file (polygons data) as a text in a table called map with two columns "ID" & "Map". when I save my map data into the cell, everything goes well. H...
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,

    There is also a limitation about the maximum string length in a single cell. The limitaion makes sense in terms of performance.

    Which custom visual would you load all the text string to? 

    Regards,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,

Why not directly connect to the JSON file using "Get Data->JSON" entry in Power BI Desktop? Would you mind sharing me the JSON file so that I can test?

Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Anonymous Thank you for the reply. Me I want to store it a text and not json format. I want to use it form a custom visual. I read that a cell can support up to 525 Mo of text file in one cell. But why isn't it working.

       

      • CahabaData's avatar
        CahabaData
        Icon for Memorable Member rankMemorable Member
        9 years ago

        in summary, as I understand your post - you have a long text field.  What is the character count length of your data field typically?

         

        what is meant by: "when I try to fetch the MAP column, the column is not complete" ? in that 'fetch' does not have formal definition in Power BI and so do you mean a visual of some kind or in the table itself after import/Get Data?