Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
amyvanhorn
Frequent Visitor

Power BI Paginated Report Err: Function 'PLACEHOLDER' encountered a Text that exceeds the maximum

Hi everyone, I had successfully created and deployed this power BI paginated report in the workspace environment for about 2 months, but now it stops working and gives me this error. Has there any updates/changes recently that messed with my report? Any idea how to fix this?

Error:

MdxScript(Model) (5, 5) Calculation error in measure '<ccon>SharePoint Images</ccon>'[<ccon>Display Image</ccon>]: Function 'PLACEHOLDER' encountered a Text that exceeds the maximum allowable length. (Microsoft Analysis Services)

 

------------------------------

Program Location:

 

   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)

   at Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.BeginNewRow()

   at Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.InternalRead()

   at Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderClientControl.QueryExec.ThreadExecution()

 

The error is for the DAX calculation of images that I turned into base64 and concatenated (this came from Power BI desktop but posted the calculation here):

f803b3ed-9871-4214-8df7-ae0faa80f41a.png

Display Image = IF(

    HASONEVALUE('SharePoint Images'[Name]),

    "data&colon;image/jpg;base64, " &

    CONCATENATEX(

        'SharePoint Images',

        'SharePoint Images'[Pic],

        ,

        'SharePoint Images'[Index],

        ASC)

        )

Many thanks.

 

1 ACCEPTED SOLUTION
amyvanhorn
Frequent Visitor

Thank you, the error was identified and resolved. One of the images was saved as a large size which broke the report.

View solution in original post

2 REPLIES 2
amyvanhorn
Frequent Visitor

Thank you, the error was identified and resolved. One of the images was saved as a large size which broke the report.

Anonymous
Not applicable

Hi @amyvanhorn ,

According to your description, it seems like you got some error in your paginated report: the function 'PLACEHOLDER' encountered a text that exceeds the maximum allowable length. However, the report worked well before.  In order to make further troubleshooting, could you please provide the following info?

  • Is there any recent changes have been made to the data or expression? If so, try reverting back to the previous version and see if the error still occurs.
  •  Please check the length of the text being passed to the ‘PLACEHOLDER’ function and ensuring that it is within the maximum allowable length.

Best Regards

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.