Help with text limit

[monguso13]

Hello, 

I am connecting to a Salesforce Report to show survey submissions. 

When I bring in the fields to Power BI there is some text being cut off with a "..." at the end. I know I am no where near the limit. How can I fix this? I've made the table as big as I could and I am still getting this issue. 

Not an expert with this tool so please suggest anything. 

Thanks.

[rainer1]

Hi,

which Visual do you use ?

Do you connect direct via Power BI Desktop or with a dataflow ?

[monguso13]

The table visual. 

Yes using Power BI Desktop.

[rainer1]

Hi, the maximal text length is a 32766 character limit on text being loaded into Power.

See this Article

https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/

-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

[zoloturu]

Hi @monguso13 ,

What is the exact length of that value which was truncated? Can you go to PowerQuery and try to check it from there?

Here is a good article by Chris Webb about text length in PowerQuery and DAX. Maybe it will make text limits more clear for you.

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups