Scheduled refresh and performance optimization Greyed out!!!

[Shafir]

Hello All, 

This morning, while attempting to manage our Data Marts, I encountered an unexpected issue. While I am able to manually refresh the Data Mart, I am unable to activate the scheduled refresh option. This discrepancy has led me to believe that there may have been alterations to the Data Mart settings, the Data Mart setting menu has changed.

Despite conducting thorough checks, I can confirm that neither a gateway issue nor a credential problem is responsible for this anomaly.

It's worth noting that our Data Marts are typically executed on a monthly basis, and I can confirm that we did not encounter any such issues during the previous month's operation.

I would greatly appreciate any insights or suggestions you may have regarding this matter. 

[Anonymous · Accepted solution]

Hi,@Shafir 
I am glad to help you.

Unfortunately, in my testing, I found that my previous bed build of datemart was also unable to configure a scheduled refresh

This issue has been confirmed as a known issue internally.

Other users are also experiencing this issue

Please be patient to wait for fixing. If there is any news, I will update it here

Thank you for your understanding.

Below I provide some possible alternatives:

1. Use API to control refreshing the semantic model
   Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn
   You can try to refresh the semantic model using the powershell command

To do this you need to install the powershell module that manages power BI.

Here are some common power shell commands that you may find useful

install

Install-Module -Name MicrosoftPowerBIMgmt   

install different modules

Install-Module -Name MicrosoftPowerBIMgmt.Workspaces

login power BI service

Connect-PowerBIServiceAccount

get workspace

Get-PowerBIWorkspace

get workspace info

Get-PowerBIWorkSpace -id "your workspaceID"

get semantic model by workspaceId

Get-PowerBIDataset -WorkspaceId " your workspaceID "

refresh semantic model

$workspaceId = " your workspaceID "

$semanticmodelId = "your semanticmodelID"

$refreshBody = [PSCustomObject]@{ type = "Full"; startTime = "2024-05-05T12:00:00Z" } | ConvertTo-Json

Invoke-PowerBIRestMethod -Url "groups/${workspaceId}/datasets/${semanticmodelId}/refreshes" -Method POST -Body $refreshBody

To be able to remotely manipulate the workspace, you need to enable XMLA endpoints
url:Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...

2. recreate a normal semantic model based on datamart's semantic model

Perform a schedule refresh on this semantic model (if feasible)
Here are my test results:

The previous setting screen is as follows:

But now it's come to this:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.