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
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous is your data source available? Maybe there is a lag to pull the data? What is your source?

 

 

Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

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