Cannot deploy Tabular Model to AAS server due to invalid PostgreSQL credentials

Matthew 121 Reputation points
2020-12-07T15:57:00.3+00:00

Hello,

I am having problem with cube deployment which is built on PostgreSQL database. Every time I try to deploy the model to AAS server, I receive following error: Cannot process database. Reason: Failed to save modifications to the server. Error returned: 'The credentials provided for the PostgreSQL source are invalid. The exception was raised by the IDbCommand interface. I am only allowed to upload metadata itself.
I receive the same error message when I try to process this table on AAS instance using SQL Server Management Studio.

The model I'm trying to deploy is not complicated itself: It contains one table from PostgreSQL database with a few simple measures (No roles or relationships created just yet).

I've npgsql connector installed and I am certain the credentials I'm providing during deployment process are correct.
I am using Visual Studio 2019 Community version.

I would strongly appreciate your help,
Matthew

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 76,746 Reputation points Microsoft Employee
    2020-12-09T04:31:15.403+00:00

    Hello @Matthew ,

    Unfortunately, Azure Database for PostgreSQL is not a supported data source of Azure Analysis Services.

    The following tables describe supported Azure data sources for Azure Analysis Services.

    46511-image.png

    Reference: Data sources supported in Azure Analysis Services

    I would suggest you to provide feedback on the same:

    https://feedback.azure.com/forums/556165-azure-analysis-services

    All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

    Hope this helps. Do let us know if you any further queries.

    ------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

0 additional answers

Sort by: Most helpful