SharePoint LIst Multi-Line Text Field Append Changes column blank

[swatson_orchard]

I have a multi-line text field in SharePoint with the Append changes to existing text option enabled. No matter what I do this column shows up blank in Power BI. Is there a way to get this information without switching this feature off?

[v-jianpeng-msft]

Hi, @swatson_orchard 

After a change has occurred to your data source, you will need to refresh your dataset to get the latest changes:

If you've already published your report to Power BI service, you'll need to follow the following tutorial to configure a refresh or perform a manual refresh:

Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thaumaturgist]

Unfortunately, there is no out-of-the-box way in Power BI to directly show the entire appended text if “Append changes” is enabled.

A potential workaround could be to create a seperate field to maintain "all text" and sync it. If you want to continue using SharePoint’s “Append changes” feature for in-browser tracking yet still need a single, consolidated text value in Power BI, you could add a workflow or Power Automate flow to concatenate all new input into a separate field. That secondary field would then store the entire conversation/thread in a standard multiline column (without append) that Power BI can easily read.

[swatson_orchard]

Thanks for the help. I just found it odd it shows up as blank in Power BI. I thought if anything it would show the last update but it doesnt look like it will show you anything at all.