Forum Discussion
Scheduled refresh and performance optimization Greyed out!!!
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.
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:- 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 MicrosoftPowerBIMgmtinstall different modules
Install-Module -Name MicrosoftPowerBIMgmt.Workspaceslogin power BI service
Connect-PowerBIServiceAccountget workspace
Get-PowerBIWorkspaceget 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 $refreshBodyTo 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 Learn- 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.
- Use API to control refreshing the semantic model
1 Reply
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:- 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 MicrosoftPowerBIMgmtinstall different modules
Install-Module -Name MicrosoftPowerBIMgmt.Workspaceslogin power BI service
Connect-PowerBIServiceAccountget workspace
Get-PowerBIWorkspaceget 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 $refreshBodyTo 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 Learn- 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.
- Use API to control refreshing the semantic model