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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your kind reply Lionel, May I ask how large is your table?

 

I have tried to remove the measure, but that particular table is still unable to import to Power BI, (the table is about 20k rows). I also tried in my company's computer uploading other excel file, but also unsuccessful for large tables.

 

 

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
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