Problems importing an excel file to Power B

[Irenemg]

Good morning,
I am having problems importing an excel file to Power BI, apparently everything is imported correctly but I have detected that some columns shorten the text not showing it in its entirety, how can I fix it?

[Anonymous]

Hi @Irenemg ,

Once you've loaded your data into Power BI the documentation says that the maximum length of a text value is “268,435,456 Unicode characters (256 mega characters) or 536,870,912 bytes”

• Is your PBI the latest version?
• Did you try to use Text.Length - PowerQuery M | Microsoft Docs  or LEN function (DAX) - DAX | Microsoft Docs  to check if the length are same in Excel and in Power BI Desktop?

Please share some screenshots to help us clarify your scenario.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Irenemg , Open power query and check for any error.

refer if needed

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.