Forum Discussion
Can we Transform a Data from a Dataset?
Hi Team,
Is there a way to load the data from a dataset and Transform in Power BI Desktop?
Regards
Deepak
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 TeamIf 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
2 Replies
Deepak3Arora , That can be done in import mode, and I doubt that for the power bi dataset. You can do a direct query. But that enables only small transformations
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 TeamIf 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
