Memory error

[ManviJ]

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 in my table visual, I am facing this error issue atached in the image. Please help if anyone can.

thankyou in advance 

[ManviJ]

The solution was to create a html view with my json string

[v-achippa · Accepted solution]

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

[v-achippa]

Hi @ManviJ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Deku for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @ManviJ,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Deku]

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?

[ManviJ]

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]

Do you really need the entire payload?

Could you truncate it or provide a link into it?