DAX calculation migrate

[Anonymous]

Hi, I need to copy report A to my pbix file, so the calculations is required to created to my report, but there are so many calculation it is too slow and inefficient, is there an efficient way for me to migrate a big number of calculation to my pbix file?

[Anonymous]

Hi @Anonymous ,

Please follow the steps in this blog.

https://forum.enterprisedna.co/t/multiple-datasets-in-same-report/14122 

Best Regards,

Jay

[Dhacd]

If you are not making any changes to the data set. Then publish the pbix to service and connect to that dataset with the new pbix. It will be a live connection.

[Anonymous]

Thanks, does you mean I need to publish and then edit report use 2 datasets?
It seems one report cannot use 2 independent datasets, or is there to be more details? Thank you

Actually I want to edit report in my pbix file and contains the content from another pbix that with a lot of calculation

[Dhacd]

We can have a live connection and another connection(import or direct query) too. All the tables in the live connections cannot be edited. but you can edit the tables which are in import mode.