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

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