Forum Discussion
Unable to connect to SSAS Tabular from Service
Thanks Ross for responding quickly. The SSAS is hosted in cloud but when I follow your process and click on the elipse I see a slightly different one -
I've also tried to click explore the option of "Analyze in Excel" and when I clicked on the option, a excel workbook was downloaded. When I opened the workbook, it prompted for the credentials to connect to Azure and when I'm done I was able to connect to the Tabular model without any issues.
Kindly let me know if you need further information.
When you connected to your SSAS, did you do so as a live connection or as an Import?
Just checked my menu from the same screen and its the same as yours. My screenshot was from the Left Hand menu, under the DATASETS section. There is a slightly different menu if you click the ... option there.
I have connected to SSAS cloud instance as a live connection. Below is the screenshot from the PBI desktop
I have connected to SSAS cloud instance as a live connection. Below is the screenshot from the PBI desktop
Great. Live connection are how mine are as well. I'm super curious to see what the left hand menu's pop up looks like.
Sorry Ross. Even after moving my head around the screen several times I couldn't find the Dataset option that you are looking for. Can you send me a screenshot of where can i find the option?
Addition info: I learned that the SSAS Azure account domain is different from the Power BI account domain. For example, my azure account is configured with [email protected] but my PowerBI service is [email protected]. But both these domain go well when I'm accessing applications in the intranet.
This might be a reason where the cloud expects the same domain to grant access permissions.