Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I have an extisting report in Service with a related semantic model. There are some hidden sheets due to data sensitivity. To establish row level security, I need to create another report with the exact same visuals but unhide all sheets. This new report will have a separate audience from the original. Can I download the semantic model, and re-upload it with a different name or do I need to use the Power BI semantic models connector under Get Data? The difference I see in the 2 approaches are:
Do both these approaches return the same result? Please advise.
Solved! Go to Solution.
Hi @user900 ,
Both methods will achieve the effect you want.
1. Download and re-upload the semantic model. This method requires publishing it back to the Power BI service under a different name. All visuals and configurations of massive reports are retained, which is a significant advantage. However, be sure to adjust your RLS settings as needed for your new audience.
2. Use the Power BI semantic model connector under Get Data. This method can be very time-consuming for reports with a large number of visuals. This approach is more suitable for scenarios that require significant changes to the data model or visuals.
Both approaches achieve the desired result, which is to create separate reports for different audiences and adjust data visibility. However, the first option (downloading and re-uploading the semantic model) may be more efficient and straightforward, since you want to maintain the same visual effect. Additionally, since you want to implement row-level security, make sure the security roles and rules are properly defined in the Power BI Desktop file before publishing.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @user900 ,
Both methods will achieve the effect you want.
1. Download and re-upload the semantic model. This method requires publishing it back to the Power BI service under a different name. All visuals and configurations of massive reports are retained, which is a significant advantage. However, be sure to adjust your RLS settings as needed for your new audience.
2. Use the Power BI semantic model connector under Get Data. This method can be very time-consuming for reports with a large number of visuals. This approach is more suitable for scenarios that require significant changes to the data model or visuals.
Both approaches achieve the desired result, which is to create separate reports for different audiences and adjust data visibility. However, the first option (downloading and re-uploading the semantic model) may be more efficient and straightforward, since you want to maintain the same visual effect. Additionally, since you want to implement row-level security, make sure the security roles and rules are properly defined in the Power BI Desktop file before publishing.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 9 | |
| 8 | |
| 8 |