This is one of the Query I use to populate the table from SharePoint - Can you pleae advise if this will work for refreshing from Power BI Service?
let
Source = SharePoint.Files("https://xxxxxxxxx.sharepoint.com/sites/ext-dwh-r-transition/", [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".csv" or [Extension] = ".xlsm" or [Extension] = ".xlsx")),
#"DWH Service Transition Assessment xlsm_https://xxxxxxxxxx sharepoint com/sites/ext-dwh-r-transition/Shared Documents/General/Transition Acceptance Criteria/" = #"Filtered Rows"{[Name="DWH Service Transition Assessment .xlsm",#"Folder Path"="https://xxxxxxxx.sharepoint.com/sites/ext-dwh-r-transition/Shared Documents/General/Transition Acceptance Criteria/"]}[Content],
#"Imported Excel Workbook" = Excel.Workbook(#"DWH Service Transition Assessment xlsm_https://xxxxxxxx sharepoint com/sites/ext-dwh-r-transition/Shared Documents/General/Transition Acceptance Criteria/"),
Anylogic_Sheet = #"Imported Excel Workbook"{[Item="Anylogic",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Anylogic_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Column1", type text}, {"Ref. No.", type any}, {"Outcome Required For Live Operations", type text}, {"BRAG#(lf)Status", type text}, {"Comments", type text}, {"Completed Evidence", type text}, {"Action Owner", type text}, {"Target Date", type date}, {"Weighting", type any}, {"score", type any}, {"%", type any}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"BRAG#(lf)Status", "BRAGStatus"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "ServiceName", each "Anylogic"),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "FromFile", each "STA")
in
#"Added Custom1"
