Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Index Error

Hi Guys,   I'm getting this error (image below) when I try to refresh it in the web, but if I check it on Desktop then refresh it, it doesn't give me any error. Any reason why is that?     ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,  have configured any scheduler for it? if so, please check any error there.

 

Also, what kind of connection it is. Does it require Gateway or details that can be given at power BI service? Make sure either Gateway is the place or credentials have been given at the service level. (Because I can see connection error)

 

If everything is set and you still have an error

You can check and log an issue at -https://community.powerbi.com/t5/Issues/idb-p/Issues

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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"