An error occurred in the ‘Sample File....

[Wilm117]

Hi all,

I am struggling with a problem in the Power Query. I have a dataset connected to some shared teams folders, but it gives some errors. 

 some of my tables load without problems and some give an error. When I refresh the Sample File and Transform Sample File, this seems to be solved. But, in one step in my data transformation i get an error in all my tables in while it's executing the step "invoke custom function1". 2 steps further ("Removed other columns1") this error suddenly disapears.

Another error message that i get is the following: 

An error occurred in the ‘Sample File (12)’ query. DataSource.Error: SharePoint: Request failed: https://provincie.sharepoint.com/sites/prjct-WerkgroepManagementcyclus/Gedeelde documenten/General/Inleveren data/10.1_DMG3_2021_xlsm/_api/contextinfo
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://provincie.sharepoint.com/sites/prjct-WerkgroepManagementcyclus
    SPRequestGuid=6a65f99f-3041-c000-8bc1-a8e21197d87c

 This error keeps coming back, and disolves when i refresh the sample file and transform sample file. 

Does anyone has an idea why this is happening? Below I added the code for more detailed info about the steps

let
    Source = SharePoint.Files("https://provincie.sharepoint.com/sites/prjct-WerkgroepManagementcyclus/", [ApiVersion = 15]),
    #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
    #"Filtered Rows3" = Table.SelectRows(#"Filtered Hidden Files1", each Text.Contains([Folder Path], "Inleveren VGR")),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Rows3", "Transform File (6)", each #"Transform File (6)"([Content])),
    #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (6)"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (6)", Table.ColumnNames(#"Transform File (6)"(#"Sample File (6)"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Asset", type text}, {"TotaalKrediet", Int64.Type}, {"WerkelijktotVorigJaar", Int64.Type}, {"jaar(t)Prog", Int64.Type}, {"jaar(t+1)Prog", Int64.Type}, {"jaar(t+2)Prog", Int64.Type}, {"jaar(t+3) Prog", Int64.Type}, {"jaar(t+4)Prog", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Asset] <> null and [Asset] <> "Let op fout in tabel Youssri (MIP Begroot) mist totaalkrediet" and [Asset] <> "Let op fout in tabel Youssri (MIP Begroot) mist werkelijk tot vorigjaar")),
    #"Merged Queries" = Table.NestedJoin(#"Filtered Rows", {"Source.Name"}, VGR, {"Source.Name"}, "VGR", JoinKind.LeftOuter),
    #"Expanded VGR" = Table.ExpandTableColumn(#"Merged Queries", "VGR", {"Index"}, {"VGR.Index"}),
    #"Filtered Rows2" = Table.SelectRows(#"Expanded VGR", each ([Asset] <> "0")),
    #"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows2",{{"TotaalKrediet", Currency.Type}, {"WerkelijktotVorigJaar", Currency.Type}, {"jaar(t)Prog", Currency.Type}, {"jaar(t+1)Prog", Currency.Type}, {"jaar(t+2)Prog", Currency.Type}, {"jaar(t+3) Prog", Currency.Type}, {"jaar(t+4)Prog", Currency.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type1", {"Source.Name", "Asset", "TotaalKrediet", "VGR.Index"}, "Jaar-t", "Bedrag Prognose"),
    #"Replaced Value" = Table.ReplaceValue(#"Unpivoted Columns","Prog","",Replacer.ReplaceText,{"Jaar-t"}),
    #"Changed Type2" = Table.TransformColumnTypes(#"Replaced Value",{{"TotaalKrediet", Int64.Type}, {"Bedrag Prognose", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type2", "Index + Asset", each [VGR.Index] & "-" & [Asset]),
    #"Changed Type3" = Table.TransformColumnTypes(#"Added Custom",{{"Index + Asset", type text}})
in
    #"Changed Type3"

Thanks`!

[Hannah_RAFI]

Were you able to resolve this? I'm getting the same thing. 

[Anonymous]

Can you post the query for the sample/transform files?

[Anonymous]

@Wilm117 
Seems error in loading 1 table caused those error in others table in the later steps. Please check whether the corresponding error data files is still stored in the original location, check the path stings carefully. 

Best Regards
Paul Zheng

[Wilm117]

While trying to load my data into PowerBI I get the following error messages. I tried several times and they also seem to change everytime i try to load my data whithout having made any changes. Maybe this is of some sort of help?

Load
VGR
Load was cancelled by an error in loading a previous table.
Doel_Radar
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
EXP_Baten
Load was cancelled by an error in loading a previous table.
EXP_Lasten
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MIP_Begroot
Load was cancelled by an error in loading a previous table.
MIP_Prognose
Load was cancelled by an error in loading a previous table.
MOP_Variabel
Load was cancelled by an error in loading a previous table.
MOP_Vast
Load was cancelled by an error in loading a previous table.
Afspraken
OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.
Risico's
Load was cancelled by an error in loading a previous table.
Tijd
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Dim_Jaar
Load was cancelled by an error in loading a previous table.
Dim_assets
Load was cancelled by an error in loading a previous table.
Dim_OmschrijvingAsset
Load was cancelled by an error in loading a previous table.
P-Zaken
Load was cancelled by an error in loading a previous table.
Close

Load
VGR
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Doel_Radar
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
EXP_Baten
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
EXP_Lasten
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MIP_Begroot
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MIP_Prognose
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MOP_Variabel
OLE DB or ODBC error: [DataSource.Error] SharePoint: Request failed: https://provincieutrecht.sharepoint.com/sites/prjct-WerkgroepManagementcyclus/Gedeelde documenten/General/Inleveren VGR/2.4_Duurzaamheid is een substantieel onderdeel van de Utrechtse landbouw_MG3_2021_xlsm/_api/contextinfo. An unexpected exception occurred.
MOP_Vast
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Afspraken
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Risico's
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Tijd
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Dim_Jaar
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Dim_assets
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Dim_OmschrijvingAsset
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
P-Zaken
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
Close