Forum Discussion
Get data from web URL is getting only 100 records
Get data from web URL is not downloading all data . It only shows 100 records in the table no matter how many records are dispalyed on the webpage. Same is not the case if i download CSV from the web page..
Is there a particular web setting in power Bi or syntax which allows downloading ALL data from a web URL
5 Replies
Is the web page perhaps paginating the table?
Hi AJ40,
Could you please post screenshots about your scenario? We need to know how you get data from web URL.
Do you use the “Publish to Web” feature and export data from there ? If that is the case, based on my test, we are not able to export data from Publish to web URL currently, however, the data displaying in the web URL exactly match that data in Power BI Service.
Thanks,
Lydia ZhangHi the page i am refferrring to is
am trying to load the historical data into power BI
\C:\LocalData\LocalData\New folder (3).jpeg)
Same issue here. My custom web API returns more than 100 records in JSON format, but it always shows only 100 rows both on Power BI desktop and Power BI service.
