The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I want to create reports that using existing Semantic model (and inherits Security and Permission setup for existing Semantice model). So I save a copy of report from "Revenue Analysis" with new name "Revenue Analysis Regional". I download the new "Revenue Analysis Regional" report to my desktop to update the visuals.
However, when I publish the new "Revenue Analysis Regional" report to Workspace, PowerBI automatically create new semantic model for Revene Analysis Regional. All existing SECURITY and PERMISSION from original "Revenue Analysis" is missing. Is it possible to publish a report from PowerBI desktop to Workspace without having new semantic model ? In other words, I want "Revenue Analysis" and "Revenue Analysis Regional" link to same single semantic model.
Pls advise
Solved! Go to Solution.
Hi @mbudiman ,
You need to do this with a Live Connected Data Model.
The Following screenshot shows how you can have a Live Connection to the Power BI Semantic Model. With this method, a single model that is present in the Power BI Service can be used across multiple reports
In your case, before publishing the report, click on this and change the data set to use the one present in the Power BI Service
Regards,
Hi @mbudiman ,
You need to do this with a Live Connected Data Model.
The Following screenshot shows how you can have a Live Connection to the Power BI Semantic Model. With this method, a single model that is present in the Power BI Service can be used across multiple reports
In your case, before publishing the report, click on this and change the data set to use the one present in the Power BI Service
Regards,
Hello @mbudiman ,
i would add on what @Thejeswar mentioned, is that you can also connect to specific tables for each report based on your needs.
the data will reflect from the main semantic model.
Proud to be a Super User! | |
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |