How to copy sales table from one PBI file to another PBI file ?

[admin11]

Hi All

I have a PBI file , which unable to refresh , so i like to copy the SALES table from power quary to another new PBI file , As you notice that right side the red color box , it have more then 20 row. like rename the column and change the date format etc.

It is possible for me , by just copy the code from advance editor :- 

Hope some one can advise me.

Paul

[V-lianl-msft]

Hi ,

Do you want to debug the error query or just copy the correct query to another file?

If  just copy the correct query to another file,please try below steps:

Select queries you want to copy from file 1 >  after that Right click and Copy the queries. Using ctrl + click you can select multiple queries.

Now go to file 2, and open Power Query Editor.

After that right click on blank area and paste the queries.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

You can copy the M code from the Advanced Editor to a new blank query (or you can just right click on the query on the left and choose copy and then paste it into the same place in a new file), but if you are unable to refresh the data, you wouldn't be able to do it in the new file either.

If you need to export the data from the report, you can use DAX Studio. You can export it as a csv and bring it into a new pbix file with the Text/CSV connector.

Pat