Forum Discussion

johnpjustus's avatar
johnpjustus
Helper IV
2 years ago

Sharepoint connection Credentials

All,   We are connecting to files in sharepoint and everything works. Now each developer would create reports either from PBI Desktop or create dataflow from PBI service from Sharepoint and when t...
Need Help
christinepayton's avatar
christinepayton
Most Valuable Professional
2 years ago

What I have done in the past is use developer credentials in the desktop client, then when publishing the first time "take over" the refresh/dataset with the service account. Subsequent publishes will still use the service account without any special treatment, it's just the first time that you need to do the takeover on the refresh. 

johnpjustus's avatar
johnpjustus
Helper IV
2 years ago

Thanks very much, I guess that should work and I just tested it.

I don't think there are any other approach to this.

 

For other database connections such as Oracle, SQL server etc., it is managed well, admin can create connection in Power BI service and share with other developers and developers when creating dataflows they can just input the connection string and it automatically authenticates using the credentials provided when creating the connection. No need for developers to enter the credentials.

 

Sharepoint is little different.

 

Thanks,

John