Forum Discussion
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...
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
v-jingzhang any ideas would be gratefully appreciated.