- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Protect advanced data editor
Hi all,
is it possible to prevent user to use advanced editor on a power bi desktop data model?
I have to share my model and users have to create mesures, columns and whatever they want. But i have to be sure that they don't modify the loading SQL script under advanced editor on each table.
It's like a protection on what a user can see or modify. Is it possible?
Regards,
Francesco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@FrancescoSCP , Publish your file, and share the dataset with other users. Ask then to add this one as a power bi dataset. They will only get the visualization tab option
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
thanks to all but that's not what i want....
i have to lock some table import so that user can't modify it. I Think it's not possible now.
Francesco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can create a dataflow they connect to. Or, if that is not an option, you can save the result of your SQL query in a separate file first, and then connect to that.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Did I answer your question? Mark my post as a solution! Kudos are also appreciated!
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypa HoosierBI on YouTube
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think no. Only Live COnnection mode.
Imported data will be available for any user who open the file
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
02-26-2024 07:01 AM | |||
03-02-2021 06:46 AM | |||
Anonymous
| 07-18-2018 05:47 AM | ||
05-03-2024 08:52 AM | |||
04-04-2024 03:49 PM |
User | Count |
---|---|
126 | |
81 | |
59 | |
57 | |
43 |
User | Count |
---|---|
183 | |
111 | |
82 | |
66 | |
51 |