title: Pivot table from Data Model shows blank rows but none in source data
body: <p>I have a table (called MFInput1) that contains multiple rows and columns and NO blank rows. Now when I summarize this data directly as a pivot table - with the first column designated as row headings - I get the format I want, without any blank rows. However, when I try to create the pivot table by adding MFInput1 to a data model, I get a &quot;(blank)&quot; row at the bottom. As mentioned, there are no blanks in the source data (and the data model as well).</p>
  <p>I need to include this table in the data model in power pivot as it has to link up with other tables to generate the final pivot report that I want and the blank row causes formula errors. I can filter out the blank row on the pivot table, but then every time the source table expands, I would have to re-filter the table to include the new entries.</p>
  <p>To summarize: pivot table generated directly from source data table (that has no blanks) has no blank rows, but if generated from the same source data via a data model, a &quot;(blank)&quot; row shows up. How do I prevent this?</p>
  <p>Any suggestions that might help would be highly appreciated. Thanks!</p>