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 not fully sure about your question, the common way is to create a semantic model in Power BI, publish it to the service and then let use connect to this model and create report.
Let’s say a company hires an external developer to create a dashboards and handling the entire ETL process, but we don’t want to give them direct access to our raw data. What would be the best security-focused approach?
Would a company-managed virtual machine with restricted access be a good solution, or are there other best practices to ensure data security while allowing development?