About the character limit when loading a query into Power BI Desktop

[Lopez0090]

I am trying to use Base64 code to display images in Power BI, but because of the character limit (32,777 characters) when loading into Power BI Desktop, the Base64 code is too long and gets cut off in the middle.

There is no limit to the number of characters in the query editor, and it looks like Power BI Desktop can hold more than 32,777 characters if you join the values (create a calculated column) after reading them.

Therefore, I would like to split the number of characters converted to Base64 by Query Editor into multiple columns of about 30,000 characters and load them into Power BI Desktop.

Is it possible to split the number of characters into multiple rows and columns like this in Query Editor?

If anyone knows how to do this, could you please let me know?

↓↓　Image of what you want to achieve

Best regards,

Lopez

[ImkeF · Accepted solution]

Hi @Lopez0090 ,

I believe this article holds the building blocks for it:

How to store tables longer than 1,1 Mio rows in an Excel-sheet using Power Query and JSON – The BIcc...

There I've split up into chunks to store in Excel, but this should work for your image data as well.