PQ Returns "Null" Rows from Dataverse Table '[Note], Column 'DocumentBody' containing Base64

[JonathanDavey1]

Hi, I have PowerApps exported the built-in Table [Note] to CSV and can render the Column 'DocumentBody' Base64 Text to an Image.

However when I connect to Dataverse [Note] using Power Query the Column 'DocumentBody' = "Null" on every Row.

The 'DocumentBody' Rows do not contain large files <1mb

Im new to all this, whats going on? How do I get to the base64 Row data within Power Query?

Thanks

Jonathan

[mit579]

Hi Jonathan - 

Did you managed to solve this, we are also facing the same issue

[JonathanDavey1]

After some deliberation MS confirmed it is by Design (doesnt work).
Its been a while since I was here, Dataverse now includes FILE and IMAGE Types, including in Teams, which function reasonably well, so recommend this path and avoid the Builtin Tables.

[Hello]

Thanks Jonathan but Dynamics uses this table internally and store images in documentbody colum. How to manage this?

[JonathanDavey1]

Hi Jing,

"Text Area" is the data type.

Power Bi Desktop / CDS / Dataverse / DefaultOrg.Dymamics.com / [annotation]

1) Import Mode

Result:

2) Query Mode

Result:

3) Power Bi ONLINE / New Dataset / Dataflow / Define New Tables / Dataverse / DefaultOrg.dynamics.com / [annotation]

Result:

Thus from every direction, PowerQuery is unable to return the row values from Builtin (Microsoft Managed) Table [annotation] column 'documentbody'

However, Power PLATFORM is able to export to csv the values (see previous screenshot) and I am able to render the base64 string to an IMAGE. So the data is there an usable, just not through PowerQuery.

Thanks

Jonathan

[v-jingzhang]

Hi @JonathanDavey1 

What is the data source? Which connector do you use to connect to the data source? Which connection mode is it, Import or DirectQuery? Which data type is this 'DocumentBody' column in the built-in table in the data source? 

The Text column has a 32766 character limit which may influence the rendering affect of large images. But it seems not the cause as your data is not loaded at present. 

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/ 

Best Regards,
Community Support Team _ Jing

[JonathanDavey1]

@v-jingzhang any ideas would be gratefully appreciated.