Forum Discussion
Problems importing an excel file to Power B
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?
2 Replies
- amitchandak
Super User
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-Lag0VOiTsIf this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. 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.
