Moving From Excel Query Editor to Power BI Power Query

[Whatever2]

Hi everyone

I've begun a report with excel query and made some transformation on my table in it , and then i uploaded them in Power BI from the excel workbook.

I just realised that to update my datat i'll need to open both excel and Power BI and hit both refresh button.

I'd like to copy/paste the transformation made in excel into Power BI is that possible ?

Or do i have to do it all over again ?

thanks in advance 

[drewlewis15 · Accepted solution]

If I am understanding your question correctly, you are wanting to copy your transformations made in Power Query (Excel) into the Query Editor in Power BI, correct?

If that's that case, then simply open your advanced editor in Power Query and copy/paste the entire code into your advacnced editor in Power BI.