Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Import from Excel Errors

Hi I'm experiencing some errors when I tried to import data from an excel which contains Power Pivot model and some measures, the table I'm having issue with is about 20,000 lines, with 6 columns. I...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi, Anonymous ,

     

    The Power Pivot model I have imported is not too big.

    I tried to import an excel with 30k rows, but which is also not too big, because I can't find a big data.

    I import the excel successfully.

     

    But I find a feature in Power BI Desktop (File -> Options and Setting -> Options):

     

    I'm not sure if the issue is related to it. You can check yours.

     

    Best regards,

    Lionel Chen

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous I never imported power pivot model in Power bI. Wondering if there is data type issue. Can you see if Power BI added a step for change data type and may be one of the column data type is not correct. I could be totally wrong here.