Forum Discussion
SharePoint LIst Multi-Line Text Field Append Changes column blank
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.
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.
Helper IUnfortunately, 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.
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.