Dataset schedule refresh for sql windows authentication server

[Sankhadeep]

Greetings All,

I am trying to schedule refresh dataset in power bi cloud server. It's only wokring whenever I am changing the premission to Database + microsoft account and publish it on power bi server. But I have connected database to a sql server with windows authentication so I have changed the permission to windows authentication and published to power bi server where dataset refresh is not happening. It; showing some acess related errors -

- “Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.”

Please help me on this.

For both cases I am using on premises data gateway provided by power bi.

[v-juanli-msft]

Hi @Sankhadeep 

Could you show screenshots when the error occurs and which is the error?

 "power bi cloud server" refer to Power BI Service, "power bi server" refer to Power BI Desktop, right?

Best Regards

Maggie

[Sankhadeep]

Hi @v-juanli-msft ,

From app.powerbi.com I am trying to reshedule dataset where I am facing error. 

From PBI desktop app I can update the dataset using same windows credentials.

PFA.dataset refresh error

[v-juanli-msft]

Hi @Sankhadeep 

When you change the permission to windows authentication in Power BI Desktop, publish to Service, do you change the credential under personal gateway?

Best Regards
Maggie

[Sankhadeep · Accepted solution]

Yes I was using personal gateway and that was the problem. Now it's working well.

Thanks for your time anyway !