Hello friends, Hope all is well! I am going crazy please help.
I made a PowerPivot from a another workbook > the sheet that it reads from is a table, range should be set with No blanks.
Please open the attached image, there you will see the PowerPivot's manage sheet (database) what is puzzling is that there are blanks in the 1st column!
I know for a fact that there are no blank rows in the data source. How can I see the manage screen without blanks?
Thank you very much in advance!
Last edited by saudi_red_neck; 10-29-2018 at 08:33 AM.
You have filter on "Project Name" column. Is it filtered for blank?
FYI - Even if file does not contain blanks. Certain file format such as CSV will generate last row as blank.
I'd always recommend using PowerQuery as ETL tool before loading to data model.
By doing so, you can check what's causing blanks to appear, and filter them out before loading to data model.
Last edited by CK76; 10-29-2018 at 09:11 AM. Reason: Added last line.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks