Forum Discussion

JonathanDavey1's avatar
JonathanDavey1
Icon for Helper I rankHelper 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
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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