Adding a new table to a dataflow using Azure

[jeynon]

Hi all, 

This seems like such a simple question but I am lost as to WHERE to access the query editor. I was told once how to do this but can't find the correct location.

A dataflow was created for an organization with tables coming from Azure. Updates every morning.

The developer has added new tables in Azure and the client wants these new tables available in the dataflow. 

When I open a report that uses the dataflow in Desktop, I click on transform data and I see all the tables in the dataflow on the left hand side. I felt like this is where I can duplicate a table, rename and change its source to the new table that was created. That doesn't fly. I am not in the correct spot.

In the Service I can't find where to access PowerQuery to duplicate and alter a table new, which is where I think I am supposed to be. 

Any help would be greatly appreciated. 

[v-prasare]

Hi @jeynon,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by community members for your issue worked for you or let us know if you need any further assistance?

@GeraldGEmerick , thanks for your prompt response

Your feedback is important to us, Looking forward to your response

Thanks,

Prashanth

[v-prasare]

Hi @jeynon,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by community members for your issue worked for you or let us know if you need any further assistance?

@GeraldGEmerick , thanks for your prompt response

Your feedback is important to us, Looking forward to your response

Thanks,

Prashanth

[GeraldGEmerick]

@jeynon If you have an existing Dataflow, just go to the workspace where that dataflow resides and then click on the name of the dataflow, the online version of the Power Query editor will launch and you can edit the query.

[jeynon]

@GeraldGEmerick You mean in the Service? When I click on any semantic models it doesn't guide me anywhere that I find Power Query.  I see some tables down the right side, and a "See what already exists" in the middle. At the top:

I feel I am in the wrong place. And THANK U for responding. Once I get there I will know what to do!

[GeraldGEmerick · Accepted solution]

@jeynon Yes, in the Service. Open up a workspace. In the left navigation, Workspaces and then choose a workspace. In the bottom half of the screen you should see all of the content that is in that workspace. Find your data flow and click on the name of the dataflow.