This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hi folks,
It looks like Power Query truncates imported fields to 1020 characters. I have seen this when loading JSON field from MySQL data source. Is there a remedy to this, I wonder?
Thanks in advance !
Solved! Go to Solution.
Hi @gvg,
Firstly, please check if you have installed the latest version of Power BI Desktop.
In addition, you could refer to this blog What Is The Maximum Length Of A Text Value In Power BI? which should be helpful.
Best Regards,
Cherry
Hi @gvg,
Firstly, please check if you have installed the latest version of Power BI Desktop.
In addition, you could refer to this blog What Is The Maximum Length Of A Text Value In Power BI? which should be helpful.
Best Regards,
Cherry
OK, this is great article. After some more investigation I figured out, that Power Query does actually import fields longer than 1020 characters, it just shows them up truncated. They appear all right in a visual.
Thanks !
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.