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
• 12,270 points
120 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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.

answered Nov 9, 2018 by Upasana
• 7,680 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
• 35,800 points
113 views
0 votes
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
• 14,080 points
1,131 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
• 35,800 points
38 views
0 votes
2 answers

Power BI service throwing 403 error when using token to embed Power BI report

To add to @Kalgi's answer, Also make ...READ MORE

answered Oct 3, 2018 in Power BI by Nilesh
• 6,900 points
325 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,040 points
48 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
• 35,800 points
30 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
• 35,800 points
51 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
• 35,800 points
53 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
• 7,680 points
127 views
0 votes
1 answer

To create link visual in Power BI

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

answered Nov 21, 2018 in Power BI by Upasana
• 7,680 points
30 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.