Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Puissance powerquery

Bonjour à tous,   Aujourd hui j'utilise l outil SAS enterprise guide pour analyser, transformer et preparer les donnees au préalable avant d'importer les fichiers dans powerbi sous forme de tables....
General Comment
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Ibendlin !

     

    Thank you for your answer which is what i thought.

    Clearly, Powerquery is not the good tools for massive manipulations.

     

lbendlin's avatar
lbendlin
Super User
4 years ago

Power Query is more of a little brother to the serious ETL tools like Informatica or SSIS.  The main purpose of Power Query is to bring the data into a format that can then be used by the Vertipaq engine. You would not use it for transporting data between different database systems, for example.  It will also struggle at the massive manipulations that you can do with Alteryx or KNime.  

 

So, for getting data into shape you should use Power Query.  For everything else you'll want to use more specialized tools (or R/Python scripting)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ibendlin !

 

Thank you for your answer which is what i thought.

Clearly, Powerquery is not the good tools for massive manipulations.