Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys,
I am connecting to a sharepoint list which includes a column of type 'multi line text' which also appends any new data. It only returns the most recent entry for this column. Is it possible to include all data?
Here is part of my advanced editor code:
let
Source = SharePoint.Tables("https://my.sharepoint.com/my_site", [Implementation=null, ApiVersion="Auto"]),
#"36a2e38a-4901-480a-a829-240abdf5a198" = Source{[Id="36a2e38a-4901-480a-a829-240abdf5a198"]}[Items],
Solved! Go to Solution.
Guys, it looks like this has been asked a few times.
If anyone comes up against the same issue, please see this post https://community.powerbi.com/t5/Desktop/SharePoint-List-with-multiple-line-column-and-quot-Append/t... which also includes a link to a good video
Guys, it looks like this has been asked a few times.
If anyone comes up against the same issue, please see this post https://community.powerbi.com/t5/Desktop/SharePoint-List-with-multiple-line-column-and-quot-Append/t... which also includes a link to a good video
Hi, @JimJim
Thanks for your sharing.It seems that you have find the solution in the video.
Please accept you reply as soluion so that other community members will easily find the solution when they get the same issue.
Best Regards,
Community Support Team _ Eason
Thanks for the link, but having read it twice, I'm still as confused. I have no idea how to make this work in Power BI. Thinking my best option is to change the sharepoint solution by removing the append changes option and building up the history using the concat function in power automate
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |