Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refresh doesn't work

Hi,   since yesterday when i refresh pbi desktop file. it never fininshed ..?  i am seeing this message for 20 mins now. normally it takes less 1 mins. do you have any clue?
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The source is Excel file and its pretty small size one..!

i don't understand what the problem is....

 

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous that's surely weird, can you check in query editor if you can preview the file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    okie i've got a new error message. it said i have too many columns and checked my query it created a lot columns.. i don't know why this happend? cos my origianl excel file is exactly same.. 

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi Anonymous 

      The maximum number of columns for every table is 16000 according to the documents.

      Please delete some unnecessary columns before import or refresh.

       

      Best Regards

      Maggie