FIeld size limitations fetching large data with HTML

[deryl1974]

Hi All,

I have some data that is fetched from sql server which seems to be too large for the column size in the Power BI Desktop. The data contains chunks for HTML with embedded base64 images and gets cut out towards the end what seems like a column size limitation.   Has anyone faced this issue and any way this can be mitigated.

Thanks for your help in advance.

Best 

[Anonymous · Accepted solution]

HI @deryl1974,
You can check the below blog to know more about the fields size limit in power query:

Chris Webb's BI Blog: What Is The Maximum Length Of A Text Value In Power BI? Chris Webb's BI Blog (...

In addition, please also check your database setting if they have limited on the result or query timeout. 
Regards,

Xiaoxin Sheng