Power BI desktop not load all rows from xls on web

[sekic]

Data source is web, public domain, link is

http://www.dzs.hr/Hrv/censuses/census2011/results/xls/Zup_01_HR.xls

xls have about 2500 rows, but only first about 500 is loaded.

Why?

[v-qiuyu-msft · Accepted solution]

Hi @sekic,

I upload your .xls file into OneDrive for Buiness, and use web data source follow this article to get data in desktop version 2.45.4704.442 64-bit (April 2017), it will retrieve 2466 rows in the STANOVNIŠTVO PREMA STAROSTI table. Please try to use the same desktop version as ours and choose STANOVNIŠTVO PREMA STAROSTI table when you get data use web data source.

Best Regards,
Qiuyun Yu

[sekic]

Works, thanks.