Error connecting to Azure SSAS server in Power-BI through Import mode

Question

I am getting an error while connecting to Azure SSAS server in Power-BI. In Power-BI, I am selecting SQL Server Analysis Services database as a data source and I am selecting Import mode. then it is throwing me an error- "The server parameter must be a valid hostname or HTTP URL." If I use 'Live connection' mode then I am able to connect but I want to do it from 'Import' mode.

so how can I get HTTP URL for SSAS server?

Answer 1

If I understand correctly, you're connecting to Azure Analysis Services (the one where you connect to asazure://). I wasn't able to reproduce this issue so I would suggest a few things.

1. Make sure you have the latest Power BI Desktop installed.

2. In Power BI Desktop, make sure you are using the correct authentication type (Organizational account). Go to File... Options... Data source settings... Global permissions. Then see if you spot your asazure:// data source listed. If so, left click it then click the Clear Permissions button. That will cause Power BI Desktop to prompt you for credentials next time. This way you can ensure you choose the proper authentication. If your asazure:// data source isn't there, move on to the next step.

3. Click Get Data and choose Analysis Services. Paste in your asazure:// into the Server textbox and check Import and click OK. On the next screen choose the Organizational Account tab on the left. Then click Sign in and choose an Azure Active Directory account (Organizational account) which has permissions to your model. Then click Connect.

Hope it helps!

To know more about Azure, join Azure course today.

Thank you!!