Unable to create linked server in SSMS to Power BI XMLA endpoint

Khanjan Shah (Maq LLC) 0 Reputation points Microsoft Vendor
2023-03-03T09:33:05.9066667+00:00

Unable to create linked server to Power BI XMLA endpoint and getting below error:

The test connection to the linked server failed. Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) 'Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "POWERBIAPI". OLE DB provider "MSOLAP" for linked server "POWERBIAPI" returned message "Errors in the OLE DB provider. Failed to load managed ADAL component". (Microsoft SQL Server, Error: 7303)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-03-06T07:03:29.55+00:00

    Hi @Khanjan Shah (Maq LLC)

    According to the error message, to resolve this issue, you can refer to below link:

    https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc917670(v=technet.10)?redirectedfrom=MSDN

    Best regards,

    Percy Tang


    If the answer is the right solution, please click "Accept Answer". 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.