Forum Discussion
Index Error
Anonymous - OK, this seems to be the same problem as here:
Change this:
= Table.AddIndexColumn(#"Added Index", "Index.1", 0, 1, Int64.Type)to this:
= Table.AddIndexColumn(#"Changed Type", "Index", 0, 1)Maybe get rid of the Int64.Type? Wait, maybe it doesn't like that you sorted the rows and didn't do a Table.Buffer? v-deddai1-msft
Hi Guys,
Thank you for the response:
amitchandak , I actually havent set any schedules yet. I just tried to refresh it On Demand and I get that error.
Greg_Deckler, here's my code (see below), I am not really sure what's happening. In the Desktop it refreshes fine but when I refresh it on Service I get the error.
let
Source = Folder.Files("C:\Users\\Productivity Raw"),
#"Removed Other Columns" = Table.SelectColumns(Source,{"Content"}),
#"Filtered Hidden Files1" = Table.SelectRows(#"Removed Other Columns", each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
#"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"name", type any}, {"productivity", type any}, {"job_count", type any}, {"total_review_time", type any}, {"total_research_time", type any}, {"total_inactive_time", type any}, {"queue", type any}, {"day", type any}, {"user_id", type any}}),
#"Extracted Date" = Table.TransformColumns(#"Changed Type",{{"day", DateTime.Date, type date}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Extracted Date",{{"total_inactive_time", type number}, {"total_research_time", type number}, {"total_review_time", type number}, {"job_count", type number}, {"productivity", type number}}),
#"Inserted End of Week" = Table.AddColumn(#"Changed Type1", "End of Week", each Date.EndOfWeek([day],1), type date),
#"Inserted Start of Month" = Table.AddColumn(#"Inserted End of Week", "Start of Month", each Date.StartOfMonth([day]), type date),
#"Removed Other Columns2" = Table.SelectColumns(#"Inserted Start of Month",{"day"}),
#"Removed Duplicates" = Table.Distinct(#"Removed Other Columns2"),
#"Sorted Rows" = Table.Sort(#"Removed Duplicates",{{"day", Order.Descending}}),
#"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 1, 1, Int64.Type),
#"Renamed Columns" = Table.RenameColumns(#"Added Index",{{"Index", "IndexDaily"}}),
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [day] <> null and [day] <> ""),
#"Changed Type2" = Table.TransformColumnTypes(#"Filtered Rows",{{"IndexDaily", type number}})
in
#"Changed Type2"
Anonymous - OK, this seems to be the same problem as here:
Change this:
= Table.AddIndexColumn(#"Added Index", "Index.1", 0, 1, Int64.Type)
to this:
= Table.AddIndexColumn(#"Changed Type", "Index", 0, 1)Maybe get rid of the Int64.Type? Wait, maybe it doesn't like that you sorted the rows and didn't do a Table.Buffer? v-deddai1-msft
It worked! Thank you so much.
Anonymous Must be some kind of bug going on in the Service or something, that issue seems to be very recent. I think they added the ability to specify the type on the Index but apparently the Service missed that memo. Did you read the memo?
That's why it happened to 4 of my PBI projects.
I honestly haven't read the memo, I just usually scan through the new updates on each month. Thank you so much for your help, man!