Admin monitoring refresh failure

[Anonymous]

Hello,

The datasets in the new Admin monitoring workspace wont refresh anymore. Also it is not possible as an Power BI admin to get an Admin role for this workspace. So i can't check te dataset settings.

Error 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 AdminInsights source are invalid. (Source at AdminInsights.)"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 706ff8a3-0141-46d3-870f-5ac5c38258b7
Request ID: aaee75b8-262c-4e9e-87a6-158967a5a2d5
Time: 2023-05-28 09:42:21Z

[karo]

@Anonymous I received great support from MS Customer Engineer assigned to my case who send me the step-by-step instruction, how to do it. Attached below. Hope it helps you as well.

The following are the steps to use PowerShell to call REST API:

• First, you need to install PowerShell version 7 on your machine (64-bit) Installing PowerShell on Windows - PowerShell | Microsoft Learn
• Open PowerShell 7.
• Install Power BI Management module: Install-Module -Name MicrosoftPowerBIMgmt (https://learn.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps#installation)
• Login to Power BI service: Connect-PowerBIServiceAccount (https://learn.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps#log-in-to-power-bi)
• Write the API call as following:
  Invoke-PowerBIRestMethod -Url ‘http://wabi-north-europe-f-primary-redirect.analysis.windows.net/v1/admin/workspaces/{insert your Admin monitoring Workspace Id}' -Method Delete
• If it will not work, please try 

  Invoke-PowerBIRestMethod -Url ‘https://api.powerbi.com/v1/admin/workspaces/{insert your Admin monitoring Workspace Id}' -Method Delete

[Anonymous]

@karo well, that worked like a charm. The workspace has been deleted using the second API call (api.powerbi.com).

Can't understand why they gave me different instructions than yourself. Let's hope refresh keeps working properly, and otherwise I know how to delete the workspace by now!

Thanks a lot!

EDIT 2023-07-03: After refreshing once, the scheduled refresh failed again with the same error message. 

[karo]

@AnonymousHow about today refresh? Also failed? I am monitoring "my" refreshes in Admin monitoring since 2 weeks now and I realized that there is additional problem over a weekends. However, I do not have yet answers from MS Support about it.

[bogdanblaga]

@Anonymous  @karo are you using elevated admin role such as Azure AD Privileged Identity Management (PIM) ?  In that case, you need to have the tenant admin role elevated during the scheduled refresh. This is a known limitation which we are working to address.

[Anonymous]

@bogdanblaga Yes I do have an elevated admin role using PIM. I haven't seen this bullet before in the known limitations page but thanks for pointing this out. Any updates regarding timelines for a fix?

Thanks in advance.

[Anonymous]

@bogdanblaga  I also do have an elevated admin role using PIM. Like Remo, I am also curious about the timeline! Thanks for your help so far.

[bogdanblaga]

Thanks both for confirming the issue. We will provide updates regarding the fix when appropriate. Appreciate your patience as we work to fix this.

Best,

Bogdan

[Anonymous]

Hello @bogdanblaga 

Thank you! I hope the fix comes soon 🙂

[Anonymous]

Hi There

I also do have PIM enabled Power Bi Admin Role, and facing the same Issue, Can you please advise what time this dataset Refresfes and is ther anyway I can refresh on demad when I am in my Tenant with PIM enabled role.

[Anonymous]

@bogdanblaga  Is there any development you can share?