Forum Discussion
ManviJ
1 year agoFrequent Visitor
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...
- 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
ManviJ
1 year agoFrequent Visitor
I am trying to create a API service logs reports to track the APIs performance where I would require this payload, is there any way to break it in some efficient manner?
Deku
1 year agoSuper User
Do you really need the entire payload?
Could you truncate it or provide a link into it?