Forum Discussion
Helper IPower BI desktop not load all rows from xls on web
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?
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
2 Replies
v-qiuyu-msftCommunity Support
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
sekicWorks, thanks.