PowerBI dataset fail on scheduled refresh

[Aigars]

Hello everyone,

I'm using Microsoft 365 usage analytics app from PowerBI apps store. I have configured report by oficial Microsoft guide:
https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/enable-usage-analytics?view=o36...

Initial connection and data loading occurs successfully with OAuth autentication type.
When I schedule daily refresh, it is failing during refresh with following error:

Last refresh failed: Thu Oct 08 2020 11:16:03 GMT+0300 (Eastern European Summer Time)
There was an error when processing the data in the dataset.Hide details
Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The credentials provided for the OData source are invalid. (Source at https://reports.office.com/pbi/v1.0/1<TENANT_GUID>/UserActivity.)"}}],"exceptionCulprit":1}}} Table: UserActivity.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 1080b5cf-1617-4df9-a6f3-4c0df7ce4651
Request ID: 8bc90250-6ea3-4cb8-9c21-335bcac58e98
Time: 2020-10-08 08:16:03Z

If I retype credentials under dataset and manually refresh, connection and data loading happens successfully.

I'm pulling out data from another Office 365 tenant using credentials with Global Reader Role.
In Office 365 tenant with PowerBI i'm Global Administrator.

Any ideas how to fix it?

[AnkitKukreja]

Hi @Aigars 

When you go to schedule refresh page, there is the option of Gateway at the top, expand that and check that it is added as a gateway and is showing green tick there.
As sometime if the gateway is based on your system password and when you change your password, it stops refreshing as password for the gateway is not valid.

Thanks,

Ankit

[Aigars]

No, Gateway not used.

Message that appear under Gateway option:

"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."

[AnkitKukreja]

Hi @Aigars 

Please go through the below microsoft documentation for your issue. Hope it helps.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

[Aigars]

Unfortunately it didn't help. I have already check it.

[AnkitKukreja]

Hi @Aigars 

I'm sorry I cannot help on this, I've to pass it on to other members.

I would advice you to raise your ticket for the same as you don't have such scenario available in docs as well.

Let community support help you on your issue.

[Aigars]

Where this "Community Support" is?

[AnkitKukreja]

Hi @Aigars 

You can find that on forum page under "Resources tab"