Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

data refresh disabled

Hello,   Woke up this morning with data refresh disabled.   Some of the the Dataset's Data Source Credentials failed to sign in. For some of the disabled ones, I could just choose oAuth2 and sig...
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi jagostinhoCT,

 

Could you please share more details about your Gateway Settings, and the Data Sources?

 

For personal gateway, there is a known issue about invalid credentials, Error messages would look like this:
"Error: The credentials provided for the dataset are invalid. Please update the credentials through a refresh or in the Data Source Settings dialog to continue."
One possible reason is the credentials need to be updated;

 

Another one is related with Mashups between a cloud source and an on-premises source.
See details below:
"Mashups between a cloud source and an on-premises source, in a single query, will fail to refresh in the personal gateway if one of the sources is using OAuth for authentication. An example of this is a mashup between CRM Online and a local SQL Server. This will fail because CRM Online requires OAuth.
This is a known issue, and being looked at.

 

To work around the problem, have a separate query for the cloud source and the on-premises source and use a merge or append query to combine them."

 

Reference:  https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshooting-power-bi-personal-gateway/

 

Hope this information would be helpful.

 

Regards,

Charlie Liao