Forum Discussion
No connection to a SSAS database with individual credentials
Hi,
I'm trying to connect to a SSAS database (MS SQL server) with Power BI Desktop. After selecting:
- "Data Source" -> "SSAS"
- filling out the server address and selecting "Import"
- and providing the credentials in "Windows" -> "Use alternate credentials"
the connection fails with the error "Object reference not set to an instance of an object.". This happens with the version 2.50.4859.782 from September 2017 and on different machines and networks.
However, I tried using the older version 2.45.4704.442 from April 2017 of Power BI Desktop and here everything works fine. Also, establishing a connection to this server from Excel and other XMLA tools works as expected.
After debugging the network traffic with Wireshark I noticed, that there is absolutely no communication from Power BI (September version) to the outside when using "Use alternate credentials" or Basic Authentication. Only when "Windows"/"Use my current credentials" is select, Power BI is speaking with the server (the login works here).
I don't know where to start to fix this. It seems that this is not a problem of the SSAS server itself. Perhaps I miss a settings change in Power BI, between the April and September version. But i can't find anything in the public change logs for the versions since April.
3 Replies
- v-jiascu-msft
Microsoft Employee
Hi mkl,
According to my test, the connector works fine.
1. What is the type of SSAS? MD or tabular?
2. What is version of SSAS?
>>>Servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services for the Power BI Desktop SSAS MD connector to work properly.
3. Did you tried to reinstall Power BI Desktop?
Reference: powerbi-desktop-ssas-multidimensional and sqlanalysisservices
Best Regards!
Dale
- arturFrequent Visitor
did you ficed that
- AnonymousNot applicable
Same kind of issue am also facing. what is the solution for this.