How to extract datasets from pbix file?

Power BI
2

Hello @dipeshkumar30,

Thank You for posting your query onto the Forum.

Since you’ve already done the data modelling and want to use the modelled data in your new PBIX file. Here’s how you can use the transformed data in your new file without going through the transformation steps again -

Under the Data View of your previous file >> Click on the 3 dots (…) ellipses >> Under that select the option of Copy Table and paste that table into the Excel file. Below is the screenshot provided for the reference -

Using Transformed Data
Using Transformed Data1916×652 205 KB

After pasting the tables into the Excel file. You can simply load that newly created Excel file into the Power BI.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh