Forum Discussion
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):
Display Image = IF(
HASONEVALUE('SharePoint Images'[Name]),
"data:image/jpg;base64, " &
CONCATENATEX(
'SharePoint Images',
'SharePoint Images'[Pic],
,
'SharePoint Images'[Index],
ASC)
)
Many thanks.
Thank you, the error was identified and resolved. One of the images was saved as a large size which broke the report.
2 Replies
Thank you, the error was identified and resolved. One of the images was saved as a large size which broke the report.
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
