Forum Discussion

Mederic's avatar
Mederic
Icon for Post Patron rankPost Patron
1 year ago
Solved

Keep the source in a range and not in a table

Hello everyone, I'm trying to import a query into Power query without transforming the source into a table. To do this, I have in the attached file, 2 queries that work but that I find a little s...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    1 year ago

    Mederic 

     

    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

     

  • Mederic's avatar
    Mederic
    1 year ago

    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

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
1 year ago

Anonymous 

 

Why have you marked 3 solutions to this which only reinforce the wrong way to do things?  The OP themself said that using a table as the data source is faster.  Surely we should be teaching people the best way to do things?

 

Regards

 

Phil