Forum Discussion

nik751's avatar
nik751
Regular Visitor
4 years ago
Solved

Data Build permissions

Hello, I have a question concerning dataset permissions. I'm attempting to give users a dataset based on a SQL query from SQL Server databases. I want users to have access to all of the tools they n...
General Comment
Interesting Links
Need Help
DataInsights's avatar
DataInsights
Super User
4 years ago

nik751,

 

Dataflows are a good option for this scenario. A dataflow is the online (PBI Service) version of Power Query. You can create a dataflow that imports data from the SQL Server databases. Then, users can connect to the dataflow from PBI Desktop and do additional transformations in local Power Query. Users will need Viewer permission to the workspace where the dataflow resides.

 

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service