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 User
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
Post PatronHello PhilipTreacy ,
Thank you for your reply,
I personally only use tables. I know that there are only advantages.
In this case, it's a simple exercise I found on the Web,
I wanted to see if it was possible to make it quicker and shorter.
I'm thinking that it might be useful one day.
Best regards