Power bi refreshing issue

[MartekABC123]

Hi

Yesterday my Power BI stopped working and refreshing and all my reports dissapeared, I updated my gateway and managed to upload a refreshed version. Now I am getting the below, can anyone help?

Last refresh failed: Wed May 22 2019 14:12:57 GMT+0100 (British Summer Time) 
It looks like the refresh token expired. Please go to this dataset's settings page, and reenter the OAuth2 credentials for the OData data source.

Underlying error message:	AADSTS50173: The provided grant has expired due to it being revoked. The user might have changed or reset their password. The grant was issued on '2019-05-14T07:28:48.9510422Z' and the TokensValidFrom date for this user is '2019-05-22T09:40:54.0000000Z'. Trace ID: 16d49688-a3c0-492d-827c-4c7ac8fb4700 Correlation ID: fc1fc494-c595-4970-9036-b9bdb29c24ad Timestamp: 2019-05-22 13:12:56Z Table: Territory.
Cluster URI:	WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID:	dc2c914e-ce46-4d7e-8e7f-ab1874fca989
Request ID:	8e0d6220-4c91-421d-95dc-63dfd5913f41
Time:	2019-05-22 13:12:57Z

[v-qiuyu-msft]

Hi @MartekABC123, 

In Power BI service, please go to Dataset Settings and find the dataset, go to Data Source Credentials tab, click on Edit Credentials for the OData data source to reenter the valid credential, then refresh the dataset again. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hey @MartekABC123 , 

Did this work for you?

[Anonymous]

Why is this an issue? We set these to automatically refresh so we don't have to babysit them. IBM's Web Query doesn't require this much attention, nor does Tableau. What's with this, Microsoft?

[TimOConnell]

We had this issue with Power BI embedded with datasets connected to Tabular. The issue occured because the user that owned the Power BI datasets had his o365 account deactivated. To resolve the issue we went to the dataset settings and pressed the "Take Over" button with an active account.

The error messages we received were not very helpful - the only thing they did was help us find this post

[Anonymous]

Hello, 

This seems so simple.

Can you please share a screen shot of how to find the: "...Go to Data Source Credentials tab..."

I cannot locate it.

Thanks

[Anonymous]

@jhad7010 Next to the dataset, you'll see icons, including what appears as a file folder, when you hover over the title.

Click that folder, and the Settings page for that data is displayed. Data Source Credentials is about halfway down the list.

Hope that helps!

K

[Anonymous]

Hi

Thanks, i do not have that icon.

See three screen snips below.

On the Power App Service, i cannot locate any place to put credentials.

My Scheduled refresh is greyed out - says i need tokens

[Anonymous]

Try Setting your Gateway first. Then set the credentials.