Forum Discussion
Sharepoint List - Documenting Changes in Field Values
- 4 years ago
Csalinas144 I know what REST URL you can use, that would give you the URL for each previous versions of the same file but I got stuck
To elaborate, if your sharepoint details are following
site_url = xyz.com/teams/Analytics Folder Name = /teams/Analytics/Shared%20Documents/DataMaster file_name =test.xlsxYou can start with a REST URL like following and wrap that in Xml.Tables(Web.Contents())
https://xyz.sharepoint.com/teams/Analytics/_api/web/GetFolderByServerRelativeUrl('/teams/Analytics/Shared%20Documents/DataMaster')/Files('test.xlsx')/versions?select=Urllet Source = Xml.Tables(Web.Contents("https://xyz.sharepoint.com/teams/Analytics/_api/web/GetFolderByServerRelativeUrl('/teams/Analytics/Shared%20Documents/DataMaster')/Files('test.xlsx')/versions?select=Url")), entry = Source{0}[entry], #"Added Custom" = Table.AddColumn(entry, "Custom", each let x =[content], y = x{0}[#"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"]{0}[properties]{0}[#"http://schemas.microsoft.com/ado/2007/08/dataservices"]{0}[Url] in "https://xyz.sharepoint.com/teams/Analytics"&y) in #"Added Custom"It will bring you here
Invoking Web.Contents on each of these URL does not return the excel and returns an error [Error Text -Specified value has invalid CRLF characters] while the same URL in browser returns that corresponding version of excel
There is a previous question on this https://community.powerbi.com/t5/Desktop/Importing-previous-versions-of-Sharepoint-Files-into-PowerB...
and maybe omeallynile can shed some light on how to resolve that.
If you change the underlying data, you need to refresh that query to update Power BI. After refreshing, Power BI no longer has any idea what the previous data was.
Power BI is not an appropriate tool for storing versions of data. You need some sort of database or similar backend to handle that sort of thing.
- Csalinas1444 years agoHelper II
What Types of coding, tools, ect. would I need to make this happen?
AlexisOlson