Forum Discussion

Whatever2's avatar
Whatever2
Helper I
8 years ago
Solved

Moving From Excel Query Editor to Power BI Power Query

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 

Need Help
  • drewlewis15's avatar
    drewlewis15
    8 years ago

    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. 

1 Reply

  • drewlewis15's avatar
    drewlewis15
    Solution Specialist
    8 years ago

    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.