MSQL database

[Anonymous]

Hello Guys,

I have made dashboard using Mysql as a datasource , but after some months database admin changed the database credentials(only password) . Now when I have corrected (only password) in datasource setting <- edit permissions its still showing me previous password .According to that I have deleted previous dashboard and dataset from services.Still it is not taking current password and I am facing issue for schedule refresh.Please help me out.Your help will be appreciated...

[vanessafvg]

@Anonymous  can you try publishing to a new name if see if it works?

[vanessafvg]

@Anonymous  also in the power bi desktop version, got to your data source settings from file / data source settings, clear the permission?

[Anonymous]

No ,I have'nt tried it. Will it affect on dashboard that I have created.

[vanessafvg]

@Anonymous  it shouldn't do but make backup incase, i think you will just have to reinput the new ones.   

[Anonymous]

Hii,

After clearing the permission ," permission is required to run this native database query" this message is getting prompt out.Thanks..

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please clear the permission and refresh the data again. BTW, you should update the password as well in Gateway for the data source.

[Anonymous]

Yes, It is working....Thanks for the solution