cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AigarsJ
Regular Visitor

PowerBI dataset fail on scheduled refresh

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?

7 REPLIES 7
AnkitKukreja
Solution Supplier
Solution Supplier

Hi @AigarsJ 

 

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

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

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

Hi @AigarsJ 

 

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

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

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

 

Hi @AigarsJ 

 

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.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Where this "Community Support" is?

Hi @AigarsJ 

 

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

Capture.JPG

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors