Forum Discussion

Maja's avatar
Maja
Regular Visitor
9 years ago
Solved

Can't import dataa from Azure Analysis

Hi, 

 

I would glad if someone could help me with import data from Azure Analysis (connect with import option).

 

I can connect with option "connec live" but when I try import data, with the same connection string, I got error "Details: "The server parameter must be a valid host name or HTTP URL."" 

 

 

Thank ou wery much!

  • parry2k's avatar
    parry2k
    9 years ago

    Ok, here is what you need to do:

     

    1. Open new powerbi report 

    2. IN drop down menu, click Options and Settings and then  Data Source settings.

    .

     

     

    3. Then select global permissions, and select azure from data source and click clear permission

     

     

    After step 3, try to create new connection to azure and follow the step I provided in my earlier post.

     

    Thanks,

    P

     

9 Replies

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    Hey,

     

    This is what you need to do to make it work:

     

     

    Step 2 - select basic, and enter your Azure AD authentication, typically full email address and password:

     

     

     

    After connect, you will see database and it should work from there.

     

    THanks,

    P

    • Maja's avatar
      Maja
      Regular Visitor
      9 years ago

      Thank you very much for your reply!

       

      I do first step exacly same as you do, and than I got the massage "Server parameter must be a valid host name or HTTP URL."

      URL that I enter is valid bacause I can conect in it with live connection.

       

      another suggestion? Did I miss something?

      • parry2k's avatar
        parry2k
        Super User
        9 years ago

        I think you already have data source created in powerbi, you need to delete/clear existing data source and then follow the steps I mentioned. Let me know if you need help on how to delete/clear data source or I will send the screen shot later today (like in 2 hour or so)

         

        Thanks,

        Parv

  • pawel_sz's avatar
    pawel_sz
    Frequent Visitor
    9 years ago

     

    The solution works BUT there's no way to refresh the data from the portal - any idea how to work around this?

     

    Thanks

    • sayaliredij's avatar
      sayaliredij
      Solution Sage
      8 years ago

      did you get any idea how to enable refresh for SSAS AZure?

  • sayaliredij's avatar
    sayaliredij
    Solution Sage
    8 years ago

    HI

     

    Could you figure out how to refresh the data when importing from azure analysis services