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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.