Saving Power BI template SQL credentials

[Graham]

I have an issue when sharing a Power BI template with a colleague.

I created a Power BI report with parameters, with a connection to our SQL server using an sql stored procedure with a Native Database Query.

I then exported the report as a Power BI template.

When I run the template, I get asked for the parameters and the connection is made and everything works as expected.

However when I share the Power BI template with another user, they enter the parameters as requested and then the credentials screen pops up and the user needs to enter the database username and password. This only happens the first time the template or any other templates are run. After that the database username and password credentials are always there.

As I need to share several templates with several different users within the company so I need a way to have the credentials for my data source in there the first time.

The credentials must be stored somewhere so I can get the credentials on the users computer without having to physically do it myself.

Thanks in advance

Graham

[payyadi]

@Graham Any solution for this? I'm in need to share template with business users and don't want them to enter DB details. Rather just choose parameters and see the report.

[Anonymous]

Hi @Graham,

Based on test, current power bi desktop seems not support to setting the public certificate of a template or a pbix file. I try to seting the datasource to public and share it, but when other people open it, power bi will ask him to input the certificate
 

Regards,

Xiaoxin Sheng