Edit PowerBi Dataset table in Query Editor

[RubySmith]

Hi, 

New to PowerBi here sorry. 

I'm building a report that started from SharePoint files, which I formatted and transformed in PowerQuery and have built some visuals in PowerBi.

Our company's created a series of datasets and related tables pointing to Production systems. They have almost real time data so I would like to add them to my report. I have added some of the tables via "Get Data > Power Bi Data sets" and can now see the tables in my PowerBi editor.

However, I now need to format and transform the data in those tables so I can use them. 

I cannot edit the imported tables in Power Query.  I thought I would be able to copy their table by creating a new table in PowerBi = *their table* (so I am not editing their table directly) then edit it in PowerQuery, but I don't seem to be able to do this. 

Can anyone help me to somehow reference their tables from Data Set, but add in my own columns and transform data? 

Thanks in advance

[amitchandak]

@RubySmith , I think you are using the live connection.

Ideally, you should not create datasets. You should create dataflow.

As of now, change the model from direct query from modelling tab

Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA

In future in Microsoft Fabric, You will be able to store and do these transformations on Lakehouse or warehouse. You can start the trail for that as of now

How to Enable Microsoft Fabric the next generation analytics for your tenant: https://youtube.com/shorts/1TxpRe6wmyw
https://learn.microsoft.com/en-us/fabric/admin/fabric-switch