Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to import a hole file that has many Excel workbooks. If I count all the summed lines of all worksheets imported, it was supposed to have, for instance, 30.000 lines, however, for some reason the power bi is importing even the empty lines, so my power bi table has 250.000 lines instead of 30.000, and most of them are blank, expect for the first column that contain the information of directory source.
How can I import only the lines that has contents?
Solved! Go to Solution.
Before you expand the table column, let's assume that Column2 in these tables is good column on which to remove nulls. You could probably use:
FilterNulls = Table.SelectRows(PreviousStepName, each [TableColumnName][Column2] <> null)
Now when you expand the table column, the nulls should be filtered out.
--Nate
Before you expand the table column, let's assume that Column2 in these tables is good column on which to remove nulls. You could probably use:
FilterNulls = Table.SelectRows(PreviousStepName, each [TableColumnName][Column2] <> null)
Now when you expand the table column, the nulls should be filtered out.
--Nate
Your file has to be set up correctly. You have a few options:
The best solution is #2 - put your data in true Excel tables. That is the best method to use to extract data from Excel. It still isn't foolproof, but is far superior to getting data off of a plain Excel sheet.
Any filtering you do would work, but may slow down the import. If you have 1,000,000 rows of data that it is bringing in but you only want 10,000, You will have to let PQ bring in all 1M and discard the 990,000 you don't want. If it is 10,000 and you only need 9,900, that isn't a huge deal, but a million is. Try formatting as a table if possible and only bring in the 10K you need to start with.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.