Forum Discussion

arndtvissing's avatar
arndtvissing
Frequent Visitor
6 years ago

XMLA endpoint Integrated Security Error

Hi community.   Im getting an error when trying to connect to Power BI XMLA endpoint in SSMS 18.1. The endpoint is working fine in Excel.   When i conncet to the XMLA endpoint in SSMS and try and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am facing precisely this same issue and I have tested across multiple Power BI models (other than using SSMS V18.4 rather than 18.1).

 

I connect to a Power BI model in Power BI Premium Capacity using a very simple connection string with no extra parameters of the form: powerbi://api.powerbi.com/v1.0/myorg/my-workspace-name

 

I can connect and see the databases and tables and can open a DAX query and 'EVALUATE' a table and see its contents.  All looks fine until I right-click a database and choose "Browse...".  I then get the error previously reported:

 

For AS Azure connections, if 'Integrated Security' connection string property is set to 'SSPI' then 'UseADALCache' connection string property cannot be specified.

 

 

This post has been dormant with no answer for a while - anyone have more information on this situation?