Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have rechecked all my data sources and I could not find Query1 to identify which datasource is causing this issue. My data source is SharePoint only and I have searched the forum for similar scenario and could not find what is the possible cause (and then how to resolve it)
Any assistance would be highly appreciated.
Hello, Did you find how to fix this ?
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"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.