https://community.fabric.microsoft.com/t5/Developer/How-to-get-the-big-objects-in-custom-visual-Primitive-Value-is/m-p/2756601#M38518 <P>Hi&nbsp;@Anonymous</a>,</P> <P>This is a limitation of the data model in Power BI - text columns cannot return more than 32,766 characters, so if you'ew creating measures from these columns they will already be truncated before they hit the custom visual's data view. <FONT face="courier new,courier">PrimitiveValue</FONT> itself doesn't have a limit and supports regular JS strings.</P> <P>If you wish to work around this in a custom visual, you will need to create a measure that combines multiple columns&nbsp; of &lt;= 32,766 characters and add that to the data view instead.</P> <P>Chris Webb (Power BI CAT) <A href="https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/" target="_self">has a series of blog posts beginning here</A> that show ways to model around these limits. <A href="https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/" target="_self">The second post in the series</A> is specifically what you'll be needing to do in your data model, but it's worth reading the whole series to understand the limitations you need to work with in Power BI.</P> <P>Regards,</P> <P>Daniel</P> Thu, 08 Sep 2022 21:38:26 GMT dm-p 2022-09-08T21:38:26Z https://community.fabric.microsoft.com/t5/Developer/How-to-get-the-big-objects-in-custom-visual-Primitive-Value-is/m-p/2755238#M38509 <P>How to get the big objects in custom visual? Primitive Value is unable to store more than 32767 characters.</P><P>I am using&nbsp;<SPAN>categoricalDataView</SPAN><SPAN>.</SPAN><SPAN>categories</SPAN><SPAN>[</SPAN><SPAN>infoFirstPosition</SPAN><SPAN>].</SPAN><SPAN>values</SPAN><SPAN>[</SPAN><SPAN>0</SPAN><SPAN>] to get the data in custom visual, but its truncating the value to 32767 characters.</SPAN></P><P>&nbsp;</P><P><SPAN>How we can overcome this?</SPAN></P> Thu, 08 Sep 2022 11:35:36 GMT https://community.fabric.microsoft.com/t5/Developer/How-to-get-the-big-objects-in-custom-visual-Primitive-Value-is/m-p/2755238#M38509 Anonymous 2022-09-08T11:35:36Z https://community.fabric.microsoft.com/t5/Developer/How-to-get-the-big-objects-in-custom-visual-Primitive-Value-is/m-p/2756601#M38518 <P>Hi&nbsp;@Anonymous</a>,</P> <P>This is a limitation of the data model in Power BI - text columns cannot return more than 32,766 characters, so if you'ew creating measures from these columns they will already be truncated before they hit the custom visual's data view. <FONT face="courier new,courier">PrimitiveValue</FONT> itself doesn't have a limit and supports regular JS strings.</P> <P>If you wish to work around this in a custom visual, you will need to create a measure that combines multiple columns&nbsp; of &lt;= 32,766 characters and add that to the data view instead.</P> <P>Chris Webb (Power BI CAT) <A href="https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/" target="_self">has a series of blog posts beginning here</A> that show ways to model around these limits. <A href="https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/" target="_self">The second post in the series</A> is specifically what you'll be needing to do in your data model, but it's worth reading the whole series to understand the limitations you need to work with in Power BI.</P> <P>Regards,</P> <P>Daniel</P> Thu, 08 Sep 2022 21:38:26 GMT https://community.fabric.microsoft.com/t5/Developer/How-to-get-the-big-objects-in-custom-visual-Primitive-Value-is/m-p/2756601#M38518 dm-p 2022-09-08T21:38:26Z