Forum Discussion

JonathanDavey1's avatar
JonathanDavey1
Helper I
4 years ago

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

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 Co...
Need Help
mit579's avatar
mit579
New Member
2 years ago

Hi Jonathan - 

 

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

  • JonathanDavey1's avatar
    JonathanDavey1
    Helper I
    2 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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