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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - OK, this seems to be the same problem as here:

https://community.powerbi.com/t5/Service/Refresh-Error-in-PowerBI-Service-No-issue-refreshing-in-Desktop/td-p/1323364

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 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It worked! Thank you so much.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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! 

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        Anonymous No problem, I was joking about the memo!! The Service needs to read the memo!!