Forum Discussion

mp1234's avatar
mp1234
Regular Visitor
1 year ago
Solved

Rendering HTML Images in Paginated Reports

I’ve been working on a solution for a reporting requirement and wanted to check if anyone has encountered a similar scenario or might have suggestions.   I’m querying data directly from a SQL Serve...
  • BhavinVyas3003's avatar
    1 year ago

    Power BI Report Builder doesn't support <img> tags in HTML, so images won't render. As a workaround, extract the image URLs from the HTML in SQL or DAX, pass them as separate fields, and display them using Image controls in the report. This allows dynamic rendering based on parameters while supporting pagination.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mp1234 ,

    Thank you for reaching out to Microsoft Fabric Community Forum.

    BhavinVyas3003 Thank you for your response.

     

    mp1234 , as @Bhavin mentioned Power BI Report Builder supports pagination but does not support rendering <img> tags in HTML. In your scenario, images are dynamic ,  so embedding is also not an option.

     

    Please try below workarounds:

    1. In Report Builder, Separate out the image URLs from the text (using SQL or Power Query), keep the text content in one field and the image URL(s) in another.
    2. In Report Builder, Use a Textbox for the text content and use Image Control with the image URL field. Set the Image control to "External" and bind it to the URL.

    This allows pagination and dynamic image rendering, bypassing the <img> tag limitation.

     

    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!

     

    Regards,

    B Manikanteswara Reddy

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mp1234 ,

     

    Thanks for your follow-up!

    Unfortunately, Power BI Report Builder (like SSRS) doesn't fully support HTML tags like <table> ,that's why your table formatting is getting lost and showing up as plain text when paginated.

     

    Please try below workarounds:

    1. If your HTML tables follow a pattern, try extracting the data into rows and columns using SQL or Power Query. Then use a Table or Matrix visual in Report Builder to show the data with proper formatting and pagination.
    2. If possible use custom app where you can use a browser control to show the full HTML as intended ,with proper table formatting.
    3. As a final option, you could pre-render the HTML into an image and show that in the report. But this isn’t great if your content changes based on filters or user input.

     

    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!

     

    Regards,

    B Manikanteswara Reddy