Forum Discussion
Different User Same Datasource in a pbix, is Dataflow a solution?
- Anonymous6 years ago
Thank you all for the help!
Anonymous - the link is helpful but it dint help much in the scenario. My data source is saleforce, only the URL can be passed as the parameter and not the credentials.
What worked for me was -
1) Created a dataflow in the service with different username in the connection.
2) Connected to dataflow and saleforce in the desktop(both with different credentails) and published in the workspace.
3) In the service (as I learnt) -
So I had to take help of a teammate to publish one data source and other was published by self so as to enable refresh to work.
Now data is getting refreshed from the same source for differnt users.
Neither one is an option. Maybe if you create two separate dataflows then it might work.
You'll have to wait for the composite data model feature that was promised for later this year.