When using the "Export Data" function from a table in Power BI Desktop (not the web service), the resulting .csv export is incomplete (missing many rows) if the table has been scrolled to the bottom ...
I'm using March 2018 release (2.56.5023.1043) of Power BI Desktop (Optimised for Server) version, also test it on Power BI Report Server March 2018 (1.2.6660.39920)release as well.
My solution is using Directquery/SQL Server/Power BI Desktop(Server)/Power BI Report Server.
I have run few tests:
1) 1303 records - 1303 exported - Correct
2) 8878 records - 8852 exported - Not correct
3) 7238 records - 7236 exported - Not correct
4) 5776 records - 5755 exported - Not correct
5) 1578 records - 1578 exported - Correct
If this issue already been fix, could anyone let me know is it something wrong with my design?