Forum Discussion

Lopez0090's avatar
Lopez0090
Icon for Helper III rankHelper III
5 years ago
Solved

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

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