Forum Discussion
Post PatronKeep the source in a range and not in a table
Why do you want to do this? You should try working with the data structures that PBI uses, it'll make life easier.
In the query in the Excel file you supply, your source data should be in an Excel table, not just a plain range. This way you won't end up with lots of empty rows.
If you don't want the source as a table, what do you want?
Regards
Phil
Hello Omid_Motamedise , Anonymous , PhilipTreacy ,
Sorry I'm back so late, but I've had a busy day.
Thank you for your suggestions, which I've just tried out.
For this small file, the execution time is more than 5-7 seconds for all tests.
So you're right, data in a table is more recommended.Thanks again
Best regards
Super UserYou have named the whole range of column A to column C by using the following code
= Excel.CurrentWorkbook(){[Name="A_C"]}[Content]
it would be better to change the name of area include your data. If you insist to named this area and use the whole columns, in the first step, filter the nun cells
- Omid_Motamedise
rewriting your query as bellow can be increase the speed also
let
Source = A_C,
#"Filtered Rows" = Table.SelectRows(Source, each ([a] <> null) or ([b] <> null) or ([c] <> null))
in
#"Filtered Rows"
MedericHello Omid_Motamedise , Anonymous , PhilipTreacy ,
Sorry I'm back so late, but I've had a busy day.
Thank you for your suggestions, which I've just tried out.
For this small file, the execution time is more than 5-7 seconds for all tests.
So you're right, data in a table is more recommended.Thanks again
Best regards