Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have an azure blob storage account with containers for each of my in-company app users. Each container has many XMLs, all following the same structure. I would like to be able to make a new report for the data in each XML.
My current setup is to have a PowerQuery with Parameters indicating the User and XML file to fetch, giving a dataset which I then feed into a standardized Power BI report. To be able to do this for each XML, I intended to clone the master report and clone the dataset, then change the PowerQuery parameters in the new dataset to indicate which new user and XML file to report on.
I see that the REST API allows me to clone the report, however I am struggeling to clone the dataset. Does anyone have any suggestions as to how to proceed?
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.