Forum Discussion

ManviJ's avatar
ManviJ
Frequent Visitor
1 year ago
Solved

Memory error

Hi, I am fetching my data from postgres(direct query), where in the table I have two fields as response payload and request payload in the json format, and when I drag and drop the response payload i...
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi ManviJ,

     

    The error likely occurs because power bi in direct query mode cannot handle very large text fields like full JSON payloads. Oversized strings can cause memory allocation failures when rendering visuals.

    • Avoid dragging full JSON strings into visuals, instead extract only key fields needed.
    • If you need to display the full JSON, use the HTML Content visual from the app source. Wrap it in a <pre> tag for formatting and use this field inside the HTML visual.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa