How to reproduce steps in PowerQuery?

[marma330]

My goal is to reproduce the steps for getting a dataset... I know how to do that in PowerBI, but not in Excel, how can I reproduce the steps in PowerQuery to get this?

I am also not sure why do I get a UNLINCENSED PRODUCT since I am using the DSVM from Azure...

[Payeras_BI · Accepted solution]

Hi @marma330 ,

In Excel, in the "Data" tab, go to "Get Data" and "Launch Query Editor".

[Icey · Accepted solution]

Hi @marma330 ,

My Excel interface is like this:

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[PhilipTreacy]

Hi @marma330 

Like so

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[marma330]

Hi @PhilipTreacy 

Let me give some context, I am reading 'advanced analytics in power bi' book, and the author says: "The xlsx workbook contains the data sets and the Power Query queries that were used to create the data set used"

Then, says: "The hard work has been done for you, but you can inspect the workbook to see how the following data sets were combined to produce the PoliticalInfoWithGDP data set."

I want to be able to reproduce those steps...

So, If I were in powerbi, I could open power query I can see the 'applied steps' section... I was looking for something similar but in Excel...

[Payeras_BI · Accepted solution]

Hi @marma330 ,

In Excel, in the "Data" tab, go to "Get Data" and "Launch Query Editor".

[PhilipTreacy]

Hi @marma330 

I'm confused by what you mean by 'reproduce the steps for getting a dataset' - this implies you already have a query and you just need to duplicate it, or copy/paste the M code into a new blank query.

If you don't have a query to start with, you have to create the steps needed. 

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[marma330]

Perhaps I stated wrongly my question. There is no PowerBI, I have that excel file with that dataset, I want to know what transformations that dataset had to get that final state.

[AlB]

Hi @marma330 

You can just copy the query in Power BI and paste it directly into the query editor of Excel.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers