SSAS Processing Erro

Jefferson Andrade 1 Reputation point
2022-10-10T11:32:15.673+00:00

Ocorreu uma falha no pedido do JSON DDL com o seguinte erro: <ccon>Failed to save modifications to the server. Error returned: '{"error": {"code": "SSAS_ShortMessage_ProcessingError","pbi.error": {"code": "SSAS_ShortMessage_ProcessingError","parameters": {},"details": [],"exceptionCulprit": 1}}}
'.</ccon>.

Technical Details:
RootActivityId: 462a04e8-edc0-4d2a-882a-91ace881db47
Date (UTC): 10/10/2022 11:09:56 AM
0: PFError::SetLastError() line 2652 + 0x0 (Sql\Picasso\Engine\src\pf\eh\pferror.cpp)
1: PFSetLastError() line 3351 + 0x0 (Sql\Picasso\Engine\src\pf\eh\pferror.cpp)
2: ConvertExceptionsToPFResult<<lambda_d359256228571b4b16c28b1cea323c28> >() line 393 + 0x34 (Sql\Picasso\Engine\src\pf\kernel\shared\pfshmacros.inl)
3: PFSetLastErrorExTag() line 3946 + 0x21 (Sql\Picasso\Engine\src\pf\eh\pferror.cpp)
4: 0x00007FFF40519B0E (symbolic name unavailable)

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,451 Reputation points
    2022-10-11T07:57:08.273+00:00

    Hi @Jefferson Andrade ,

    Welcome to Microsoft Q&A!
    This is an English forum. For the convenience of members worldwide who can benefit from the posts it is recommended that you use English.
    Here is a similar thread: SSAS Processing Error with no additional details
    You can take following steps:

    • Create a SQL Server login account
    • Create a user for the login on the required database
    • Add to the db_datareader role
    • Use this account for the data source connection in Analysis Services
    • Redeploy the model
      If this does not solve your problem, you can add more details here.

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments