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

0 votes

1 answer

837 views

sql-server ssms linked-server powerbi azure-analysis-services

                          Unable to create linked server to **Power BI XMLA endpoint** in **SSMS** 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)
                        

Asked by Khanjan Shah (1 rep)

Mar 10, 2023, 12:12 PM
Last activity: Feb 13, 2024, 08:06 PM

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

Related Questions