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...
Need Help
  • 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

v-achippa's avatar
v-achippa
Community Support
1 year ago

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's avatar
v-achippa
Community Support
1 year ago

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