Forum Discussion
Dataflows & Gateway Permissions
Responsive ResidentHi Anonymous !
Your analysts should build their reports and datasets in Desktop by collating the data sources as they normally do. When you publish to the service, the Gateway's job is to connect the existing queries to it's source using the stored credentials in the pbix file. The credentials used will be the same as the one the team of analysts currently use to build the report in Dekstop.
As of this date, Dataflows are currently not able to do what you would like. You can try to use the method I suggested and wait for future product releases and watch the idea blog to see if it gathers any traction.
Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!
Thanks, that's what the users are currently doing, the problem is that by having user access to the gateway data source they are also able to create dataflows that use the gateway data source to gain access to the whole warehouse.
Your line:
"The credentials used will be the same as the one the team of analysts currently use to build the report in Dekstop."
The analysts each have their own credentials...so are you saying we should create gateway data sources for each person?