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?

[Thaumaturgist · Accepted solution]

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.

[v-prasare]

Hi @swatson_orchard,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @swatson_orchard,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @swatson_orchard,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@Anonymous & @Thaumaturgist  , Thanks for your promt response.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[Anonymous · Accepted solution]

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 · Accepted solution]

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.