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
Not sure why you'd want to do this really or how it would be useful. Just makes things harder when you're not using the data structures the program uses and relies on for its functions and other functionality to work.
Phil
MedericIt was just out of curiosity, but it's true, it's not really recommended this way.
It's not very important for me to know how to do it. Have a nice evening
Best regards