Forum Discussion

jvanveelen's avatar
jvanveelen
Regular Visitor
1 year ago
Solved

connection to Bi semantic model

Hi all,   Not sure if i picked the right board for this problem. I have a customer that has issues with analyse in Excel.  The datamodels are located on an Azure analysis server, but when i want ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jvanveelen ,

     

    Since your server is on Azure, you should use the fully qualified domain name (FQDN) of your Azure SQL server. It typically looks like yourservername.database.windows.net.Use the credentials that you set up when you created the Azure SQL server. This usually includes the admin username and password.

    Please check the link above.

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jvanveelen ,

 

Ensure that you have the appropriate licenses for both Azure Analysis Services and the users trying to connect. Users typically need a Power BI Pro license or higher to use certain features.
If you're using an on-premises data gateway, make sure it is properly configured and that the gateway is up and running. The gateway should be able to connect to both the on-premises data source and Azure Analysis Services.

Learn how to connect to Azure Analysis Services with Excel | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

jvanveelen's avatar
jvanveelen
Regular Visitor
1 year ago

The appropriate licenses for both are correct. also the onpremise gateway i configured properly and up and running. 
Still receiving the message host is unknown. and then receiving a message to enter a servername and credentials. Because server is located on Azure what do i have to fill in there? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi jvanveelen ,

     

    Since your server is on Azure, you should use the fully qualified domain name (FQDN) of your Azure SQL server. It typically looks like yourservername.database.windows.net.Use the credentials that you set up when you created the Azure SQL server. This usually includes the admin username and password.

    Please check the link above.

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.