Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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 @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
Unfortunately it didn't help. I have already check it.
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.
Where this "Community Support" is?
Hi @Aigars
You can find that on forum page under "Resources tab"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.