Change existing PBIX dataset connection from Excel to a Power Bi Dataset

[amirghaderi]

I have a PBIX file which is linked to Excel files in sharepoint site. The PBIX file is ready the data from Excel, then in power query transformed and pulled to the dataset and relationship has been established, reports generated. Now, I want to migrate that to have dataflow in Power Bi service, dataset from Power Bi service, and use the existing reports. I have figured out how to copy the queries from desktop version to Dataflow. But, I am struggling to find an easy way convert my existing PBIX file with all its relationship to a proper datas et which is linked to data flow. Basically, I am trying to save time not to start from scratch. Is there any easy way to replace the data source for PBIX file to be Power Bi dataflow.

For example, if I have table A in desktop version which is from excel file, I want to change its source to be Table A in power Bi dataflow service.

Thanks,

Amir

[bcdobbs · Accepted solution]

In a new pbix file connect to each entity (table) in your dataflow.

Open your existing file and click transform data. Go into each table and click advanced editor.

If you replace the M code in there with the stuff you just created in the new pbix it should all pick up fine.