Forum Discussion
Table export does not show all rows
I've seen several posts about an export from a table doesn't show all the rows. The posts explain about limitations, but no suggestions (that i can find) on why and how to fix. My report has one...
Anonymous , Try analyze in excel and see if you get better results
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
amitchandak I've tried Analyze in Excel, however it shows all the raw data from the SQL in a pivot, instead of just the data in the table. The table is pulling from SQL server and shows 6 columns and the goal of the table is for the end user to click and export the data from the table in just a few clicks. if they use Analyze in Excel, i might as well pull the data in Excel and email it..