Data Source refresh - Credential issue

[kkalyanthaya]

I have connected to Azure Analysis service from PBI desktop and published the file in Power BI Service WorkSpace.

The data set in the service does not seem to refresh because of Data Source credentials issue :

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

However the same credentials works fine on PBI desktop and the data set refreshes.

Note: Gate Connection in Dataset settings says - "You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect."

Can someone suggest any fix for this ?

[Anonymous]

This issue is no longer at the support page, but I still got the issue when trying to set up the scheduled refresh.

[v-shex-msft]

HI @kkalyanthaya,

This known issue will be fixed on 6/8/2018. You can look at support page to know more about this.

Users may not be able to set credentials if they are using OAuth2 for SQL Azure or AS Azure data sources. Engineers are aware of the issue and are working on a fix . Next Update @06/08/2018 22:30 UTC.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi, thanks for the update, And it's good to know that the fault is not in our environment .

[Anonymous]

I have had this same but we are trying to connect to a SQL Server, but the thing is that I've been trying to log in with the database creditentials.

Details

[v-shex-msft]

Hi @kkalyanthaya,

I can reproduce your issue, it seems like oauth credentials not works on service side. 

I will report this to power bi team and update here if any feedback.

Regards,

Xiaoxin Sheng