Forum Discussion
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...
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
String have a max size in Power BI. You could split the payload into multiple rows or reduce its size in some why.
What are you trying to do?
