Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
HI Chandra, can you provide detailed steps what needs to be check?
Unable to refresh Azure Analysis Services when dtabase type is set to full.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZT%3C/text%3E%3C/svg%3E)
Zero Trust Solutions
0
Reputation points
The remote server return an error: 400 Bad Request when refresh type is set to full for the database.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla 8,310 Reputation points Microsoft Vendor2025-02-14T07:04:27.4533333+00:00 Thanks for posting your query!
The error message "
The remote server returned an error: 400 Bad Request" when performing a full refresh in Azure Analysis Services suggests that the request sent to AAS is either malformed, contains invalid parameters, or exceeds a limit imposed by the service.Here are few considerations and troubleshooting steps:
Authentication & Access Validation - Ensure that your credentials are correct and that Azure services are
allowed to access your AAS instance. If using a service principal, confirm that it hasAnalysis Services Administratorpermissions.For more details, please refer: Manage server administrators
Invalid Request Format - The API request or the command being used to trigger the refresh might be incorrect. The body of the request may be missing required parameters.
Exceeding Model or Query Limits - Azure Analysis Services has limits on model size, query execution time, and the number of objects processed simultaneously. A full refresh loads all data from the source, so large models can hit memory or resource constraints.
Use the Latest SSMS Version - If running the refresh via SQL Server Management Studio, ensure you are using SSMS 18.8 or higher, as older versions may not handle long-running refreshes properly.
For additional information, please refer the following Microsoft documentations:
Troubleshoot scheduled refresh for Azure SQL databases in Power BI
Troubleshoot XMLA endpoint connectivity
Download SQL Server Management Studio (SSMS)
I hope this information helps. Please do let us know if you have any further queries.
Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Thank you.
Sign in to comment
2 answers
Sort by: Most helpful
-
Zero Trust Solutions 0 Reputation points
2025-02-14T07:06:18.2966667+00:00 -
Chandra Boorla 8,310 Reputation points Microsoft Vendor
2025-02-14T08:41:28.3766667+00:00 Thank you for your follow-up question.
To assist you better, could you provide some additional details?
Could you confirm the details regarding the role "Analysis Services Admins" below?
How are you triggering the full refresh?
- REST API
- PowerShell
- SQL Server Management Studio (SSMS)
- Azure Data Factory (ADF) / Logic Apps
Are there any additional error messages or logs?
Are you using an on-premises data source with a gateway?
Is this issue happening consistently or intermittently?
Could you please provide these details, so that we can assist further in identifying the root cause and recommending the best solution. Looking forward to your response!
Thank you.
Sign in to comment -
-
Zero Trust Solutions 0 Reputation points
2025-02-14T07:11:32.35+00:00 Also, the links provided are for power bi