Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
Thank you, the error was identified and resolved. One of the images was saved as a large size which broke the report.
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?
Best Regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
10 | |
3 | |
3 | |
2 | |
2 |