Forum Discussion
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...
Hi arndtvissing ,
According to your error message, It seems like your connection string contains some properties strings which xmla endpoint does not recognized.
I'd like to suggest you remove mentioned property and try again.
BTW, you can also take a look at following links about power bi xmla endpoint features:
Power BI open-platform connectivity with XMLA endpoints public preview
What Is the XMLA Endpoint for Power BI and Why Should I Care?
Regards,
Xiaoxin Sheng
thanks. but my connection string is like below:
powerbi://api.powerbi.com/v1.0/myorg/test XMLA
I do not specify any properties besides the path given by powerbi service