Dynamic Credentials for SQL Server Connection using Parameter

[Anonymous]

Hi,

I have to connect Azure SQL DB from Power BI/

I have created Parameters for SQL Server Name and SQL DB name but can't parameterize the DBUsername and Password.Need help on this.

Is there any other way where we can read the DataBase details from a text file and load the data in Power BI?

[v-xicai]

Hi  @Anonymous  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[Anonymous]

Thanks @v-xicai .

We are working to find a permanent&proper  solution this.Your idea definitely helped us.Thanks for your time.

For the time being, we will do it manually.

[v-xicai · Accepted solution]

Hi @Anonymous ,

It is unavailable to get such a different config files for the same .pbix file in Power BI currently. You can come up a new idea about that , and add your comments there to improve Power BI for making this feature coming sooner.

As a workaround, you may publish the same .pbix file to your goal workspaces, then change the parameters about the Azure SQ DB credentials in different workspaces in Power BI Service.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mariusz]

Hi @Anonymous 

Can you describe what is your final goal in more detail?

Why do you need to use SQL credentials dynamically?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Anonymous]

Thanks @Mariusz  for your quick response.

We have 3 environments(workspace) and we want to use a config file or similar thing which will store DB details.When the reports will be pubslushed to Power BI service, we will use the same .pbix file with a different Config file.So that, don't have to open the file everytime and change the DB details for different environments. 

[Mariusz]

Hi @Anonymous 

You store your credentials is gateway connection, so you don't need to pass it as parameters

Best Regards,
Mariusz

[Anonymous]

Hi @Mariusz 

My Database is in cloud.Why do I need a Gateway?

Could you please elaborate.

[Mariusz]

Hi @Anonymous 

Yes, you mentioned Azure sorry, it will be data source credentials in you data source setting I guess.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.