Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
I’m using Power BI Embedded in my web application with an embed token that allows users to edit reports from the frontend.
Here is the current workflow:
Now I want to extend this process.
After the user saves the edited cloned report, I want to automatically create another clone of that edited report, but with all filters and slicers cleared, even if the user has set default slicer or filter selections in the edited report.
So essentially the flow would be:
Original Report
↓
Clone #1 → User edits and saves (may contain default slicers/filters)
↓
Clone #2 → Same report structure but with cleared/default filters & slicersGoal:
The second clone should have the same visuals and report structure, but no default filter or slicer selections applied, regardless of what the user configured in the edited report.
Questions:
Solved! Go to Solution.
Hi @Nahid_SJ
Thanks for reaching out to the Microsoft Fabric Community forum.
When using the Power BI Clone Report API, the cloned report is an exact copy of the source, including its report definition and any saved filter or slicer states. The API does not offer an option to clear or override slicer or filter selections during cloning. This means that any default slicer or filter selections in the original report will also appear in the clone.
If you want to create a cloned report without the filters you should first clone that report and then change filters dynamically using Power BI JavaScript SDK, you can call methods like await page.updateFilters(models.FiltersOperations.RemoveAll); to clear filters before saving. In conclusion, since the Clone Report API copies the current state of the report, programmatically clearing filters is the best ways to ensure the cloned report does not contain unwanted filter selections.
Use filters in a Power BI embedded analytics report | Microsoft Learn
Use slicers in Power BI embedded analytics | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi @Nahid_SJ
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
Hi @Nahid_SJ
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Hi @Nahid_SJ
Thanks for reaching out to the Microsoft Fabric Community forum.
When using the Power BI Clone Report API, the cloned report is an exact copy of the source, including its report definition and any saved filter or slicer states. The API does not offer an option to clear or override slicer or filter selections during cloning. This means that any default slicer or filter selections in the original report will also appear in the clone.
If you want to create a cloned report without the filters you should first clone that report and then change filters dynamically using Power BI JavaScript SDK, you can call methods like await page.updateFilters(models.FiltersOperations.RemoveAll); to clear filters before saving. In conclusion, since the Clone Report API copies the current state of the report, programmatically clearing filters is the best ways to ensure the cloned report does not contain unwanted filter selections.
Use filters in a Power BI embedded analytics report | Microsoft Learn
Use slicers in Power BI embedded analytics | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Thanks for the valuable information. Based on your information, i just changed by business requirement and solve internally . Thanks for the information .
Hi @Nahid_SJ ,
We really appreciate your efforts and for letting us know the update on the issue.
Please continue using fabric community forum for your further assistance.
Regards
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |