Truncated data due to size limits on a file of 97.3kb

[Rowana]

Don't know why I cannot import data, 93.7kb, 571 lines, 22 columns. There is no information behind the information button. I cannot find information either on size limits

Hellllpppp 

[v-qiuyu-msft]

Hi @Rowana,

Which kind of file do you want to import? Does the issue happen in Power BI desktop? Is there any error message pops out when you import data? 

Is it possible to share the file with us so we can test on our side to see if the same issue occurs? 

Best Regards,
Qiuyun Yu 

[Rowana]

Hi Vicky, thanks for getting back. It is resolved now. It was in power BI Desktop. I had clicked on the table o the table and the message came up that the data was truncated. However, I had not actually ticked the box for table or database. When I click the box, the load button becomes yellow. 

I think that it would be better if the information button would actually give information to this effect. Such a simple thing which wasted a lot of time.

Best Regards

Rowana

[v-qiuyu-msft]

Hi @Rowana,

Thanks for your update. You can submit your feedback here: https://ideas.powerbi.com/forums/265200-power-bi-ideas

As the issue is resolved, may I close this thread? 

Best Regards,
Qiuyun Yu