Reply
FrancescoSCP
Helper III
Helper III
Partially syndicated - Outbound

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

4 REPLIES 4
amitchandak
Super User
Super User

Syndicated - Outbound

@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

Join us as experts from around the world come together to shape the future of data and AI!
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

Syndicated - Outbound

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

mahoneypat
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

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


az38
Community Champion
Community Champion

Syndicated - Outbound

@FrancescoSCP 

I think no. Only Live COnnection mode.

Imported data will be available for any user who open the file


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)