Can we Transform a Data from a Dataset?

Hi Deepak3Arora ,

If the dataset uses import mode and you can download a PBIX file, then you can use this file and transform the data in it. You can connect to the dataset from the desktop, but the connection mode that can be used at present is Live connection or Direct query. In Live connection or Direct query modes, data will not load to the desktop, and limited transformations of data are supported in DQ mode.

Not sure if the product group will roll out more schemas to connect to datasets in the future. For such kind needs. We would suggest you submit an idea in Power BI Ideas: Ideas

It’s a place where the product group collects suggestions from users to improve the features of this product. Thanks in advance!

For your reference:

Connect to datasets in the Power BI service from Power BI Desktop

Using DirectQuery for datasets and Analysis Services (preview)

Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision!

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data