Forum Discussion
Best Practices for Developing Dashboards Without Direct Data Access
FelipMark I think this question is more on to the access and security on the data source, not more of a Power BI question.
For example, a SQL server, admin can restrict access to what table a user can do, and also have read only access, and control from which IP a user can access. Once it is all in place, it will be the same using data from SSMS or Power BI.
FelipMark If I understand your question correctly, use I have used "jump boxes" in the past in order to develop Power BI reports. Often this is coupled with a VPN for even more security.
In our org, we have VMs that external developers can only access via a private VPN, and they operate under NDAs. Additionally, they log their changes using version control software. It is not much different from any other software development project. And proper oversight requires a scrum master because there are always individuals who refuse to fully comply. There is no complete panacea beyond in-house development. All the mantras: caveat emptor, ymmv, you get what you pay for, etc. apply.