Error message with loading new Excel dataset "There was an issue loading your Excel DataSet..."

Options
GretchenC
GretchenC Member
in Archive

Getting error message when trying to upload new dataset/Excel doc. "There was an issue loading your Excel DataSet. Please refresh the page or try again."  Tried refreshing page, removing all formulas, renaming worksheet to remove characters, renaming doc, clearing cache.  Preview looks good but keep getting error message upon "save". Any ideas?

Comments

  • Godzilla
    Godzilla Contributor
    Options

    make sure you don't have duplicate or blank column names.

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • GretchenC
    GretchenC Member
    Options

    Don't have duplicate or empty column names. also tried removing filters and no cigar. Any other ideas?  I've loaded a number of Excel docs and never had this error before now.

  • Anthony_G
    Anthony_G Member
    Options

    Check to make sure you've chosen 'Dataset Type Excel' and not 'Dataset Type CSV'

  • Godzilla
    Godzilla Contributor
    Options

    try deleting few of the blank columns at the end of your file just incase it's trying to load those. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • GretchenC
    GretchenC Member
    Options

    Yes, confirmed choosing Excel, and confirmed the file is saved as excel. Any other thoughts?

  • Anthony_G
    Anthony_G Member
    Options

    Are you using Domo workbench or the web upload? The upload could potentially work in Workbench, if not it might at least tell you what the error is with the spreadsheet.

  • GretchenC
    GretchenC Member
    Options

    Turns out there was a glitch with Domo.  At the end of the day, about 20 new data sets popped in from each of my attempts.  Wonder if there is an overall issue with Excel sets because I just notice several of my cards driven by excel sets were working just fine and suddenly are not. I've not touched those datasets or cards in over a week, except today to rename the card to show it is under revision)

  • Godzilla
    Godzilla Contributor
    Options

    they recently had a release so may have broken something in that release. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Categories