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

0 votes
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?
Nov 9, 2018 in Power BI by Shubham
• 13,490 points
2,645 views

1 answer to this question.

0 votes

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!!

answered Nov 9, 2018 by Upasana
• 8,620 points

Related Questions In Power BI

+1 vote
2 answers

403 error thrown by power bi report server when trying to get list of data sets

Hey @saranya, Try removing the header and ...READ MORE

answered Oct 29, 2018 in Power BI by Kalgi
• 52,350 points
4,944 views
0 votes
1 answer

How to save power bi reports in power bi server?

Follow the below steps: 1. install Power BI Desktop ...READ MORE

answered Oct 29, 2019 in Power BI by anonymous
• 33,030 points
805 views
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,540 points
13,950 views
0 votes
1 answer

Switch Power BI data sources from Excel to Azure analysis services

One option that you should consider would ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,350 points
663 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
1,267 views
0 votes
1 answer

How to assign Power BI license to a new user

The assign license method of MS Graph API might ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 52,350 points
854 views
0 votes
1 answer

Where is Power Bi being hosted?

Power BI is currently cloud hosted by ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,350 points
1,035 views
0 votes
1 answer

Power BI Report Viewing on Local Repository?

Use REST API to embed the reports in ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,350 points
784 views
0 votes
1 answer

Call Azure API with nextLink (next page) in Power BI

Here is something you could try or ...READ MORE

answered Nov 12, 2018 in Power BI by Upasana
• 8,620 points
1,675 views
0 votes
1 answer

To create link visual in Power BI

You can disable sandboxing by adding this ...READ MORE

answered Nov 22, 2018 in Power BI by Upasana
• 8,620 points
869 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP