PQ display GL Table loading error msg , May i know how to clear them ?

[admin11]

Hi All

@mahoneypat manage to help to save a lot of my time because i don't need to create my PBI file from zero, which will need to spend a lot of un-productive time. one of the reasons i have issue it is due to some how when i refresh , it does not allow me to access GL table raw data from share point.

Now i want to solve my GL table error. yesterday i solve by delete GL table , CRM Table , INVC Table , so that i can refresh. 

I have 2 approach :-

Option 1 I manually import the GL , CRM , INVC Table to PBI.

This approach will work , as it will take longer time. 

Option 2 is identify the error , and try to clear the error. 

This approach will be better , because i will be able to find out where go wrong ? in case the similar issue happen , i am able to solve it.

Below screen shot is GL Table error msg :-

Can some one advise me how to clear the error ? As you can notice those msg highlight in yellow. 

Hint :- I notice that the path have change  for GL Table load :-

 https://isdnholdings.sharepoint.com/sites/FTDSGL/

The above path name DS is missing , no wonder PBI cannot access GL raw table.

I have try to change the script , but i still get error msg :-

My Script , FTDSGL is correct path name :-

let
Source = SharePoint.Files("https://isdnholdings.sharepoint.com/sites/FTDSGL/", [ApiVersion = 15]),
#"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (15)", each #"Transform File (15)"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (15)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (15)", Table.ColumnNames(#"Transform File (15)"(#"Sample File (15)"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"GL Code", Int64.Type}, {"GL Description", type text}, {"Type", type text}, {"Month", Int64.Type}, {"Year", Int64.Type}, {"Posting Date", type date}, {"AccCur", type any}, {"AccConvRate", Int64.Type}, {"C/D", type number}, {"CurrencyValue", Int64.Type}, {"Reporting Code", Int64.Type}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"C/D", "AMT"}}),
#"Appended Query" = Table.Combine({#"Renamed Columns", GL_I})
in
#"Appended Query"

Paul Yeo

[AllisonKennedy]

@admin11  When you click on the Invoke Custom Function1 step, what does the 'Transform File (15)" column look like? It should say 'table' lots of times, but some (or all) might have an error?