Forum Discussion
Different User Same Datasource in a pbix, is Dataflow a solution?
I need to connect to Salesforce with 2 different usernames in the same pbix. As we cant do that in Desktop since the credentails gets overwritten.
In order to overcome that -
1) can we publish/create the dataset in the service and then connect to it thru desktop
2) create a dataflow in the service and then connect to it thru desktop
What is advisable in the scenario.
thanks in advance.
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.
4 Replies
Hi Anonymous ,
You can connect the dataset on Service through Desktop but i doubt if it will solve your problem.
Please take a look at below artical about how to switch datasource through parameters.
Best Regards,
Jay
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.
I am not familiar with Salesforce as a datasource, however I encountered a similiar issue with another source that may be helpful.
Our workaround was to create a service account that had access to all the information and then published the solution with this service account. This way the service account's is used as the user.
