Forum Discussion
Clone dataset programmatically
hi, Anonymous
I think you could export to multiple pbit files and then modify the query for different dataset, now publish different report.
https://fileinfo.com/extension/pbit
Regards,
Lin
hi Anonymous
I think use PowerQuery parameters is a great way for you.
And you could also try this way:
Copy the the M code in the Advanced Editor and then just adjust the conditinonal like PowerQuery parameters, now create a new blank query and paste the code in its Advanced Editor.
https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#the-advanced-editor
https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks#query-formulas
For clone dataset by Rest API, it is not available in power bi for now, please refer to this document:
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets
Regards,
Lin
Hi v-lili6-msft
I have indeed already used a PowerQuery with parameters, however I cannot modify the query in the same dataset, since I want the cloned reports to connect to different datasets. Is there any way to achieve this?
hi, Anonymous
I think you could export to multiple pbit files and then modify the query for different dataset, now publish different report.
https://fileinfo.com/extension/pbit
Regards,
Lin
Hi v-lili6-msft ,
Thank you, this is the conclusion I came to aswell, and will attempt to implement.
Regards,
Edvard