Can Data Source credentials in service be different than Dataset owner's for Smartsheet?

[meganarp]

Hi,

I am using Smartsheet as a datasource and wondering if it is possible to use a service account's credentials instead of the Data Set Owner's for the 'Data source credetials' section within the service?

Currently, it seems to take the SSO of the data set owner, even when signing out for that user and starting a new connection with the service account's details. It still continues to show the data set owner signed in. I have signed out of the Smartsheet authentication, signed out of PBI service, cleared cache, started new sessions and it still shows data set owner signed in even when using service account's email instead.  The service account does have proper access to Smartsheet

Is this possible?

Thanks,

Megan

[tackytechtom]

Hi @meganarp ,

As far as I know, it's the dataset owner's credentials being used unless you do some username + password approach. You might want to consider to make the service account (service principal in azure) the owner of the dataset. Unfortunately, this is only possible programmatically for now.

Here a blog post that might help you with it:

https://www.tackytech.blog/how-to-make-a-service-principal-the-owner-of-a-power-bi-dataset/

You do not need to use azure devops, and you could run the PowerShell script from your own machine.

Please note, after the service principal has taken over the dataset, you probably need to update the credentials while logged in as the Service Principal (dataset owner). In the blog post above, it is done for an Azure SQL Database.

Also, there is this other post in this forum, where someone tries to do something similar:

Re: How to use service principle to refresh a sing... - Microsoft Power BI Community

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/