We are attempting to connect Power BI Desktop to explore data residing in a Hosted Tabular Analysis Services Cube that is installed on an Azure VM in another Domain. The connection string is xxxx.australiaeast.cloudapp.azure.com:2381. No gateways are installed yet as we are just doing initial data discovery on the source.
There is no domain connecting the workstation running Power BI Desktop and the Hosted Azure Analysis Services VM however the same connection string works in Excel.
When using Import we get the error "user was not authorized".
When using Live we get the error "connection timeout or server name is incorrect".
We are having the same issue. Did you find a solution. I would really appreciate if you can share the solution. Cheers!
i am having the same issue and I suspect its a firewall issue on the port
@vanessafvg I don't think it's a firewall issue. I'm able to connect to the Cube using Excel eventhough Excel cannot access the domain where the Cube is hosted. We are using a site-to-site vpn. I suspect it's the way Power BI Desktop behaves when connecting to Analysis Services hosted in other domains, it somehow likes to authenticate the user remotely instead of passing the credentials to the server to do the job and Excel does this nicely and it works from Excel. What do you think?
@vanessafvg I found a workaround which actually does work. I've tried it just now. Use the following command and it does the trick.
runas /netonly /user:<domain>\<username> <path to PBID executable>
Let me know if it works for you.
nope that doesn't work, i had tried that already. We use this in our environments too with different applications, however does not work with Power BI
@vanessafvg Can you please provide more details like how's the setup (is it site-to-site vpn, etc.), where the destination analysis services is present (same domain, other domain), are you able to connect to the cube via Excel.
In my scenario, I could connect to the Cube from Excel but Power BI Desktop was unable to connect.
I have the same issue with 2 VM on 2 different domains. One VM hosts SSAS Tabular, the 2nd one hosts Power BI Desktop.
Any solutions or workaround please?