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.

Jai-Rathinavel's avatar
Jai-Rathinavel
Icon for Super User rankSuper User
1 year ago

Hi jvanveelen , \
1. Check with your admin if the below option is enabled in your tenant.

 

 

2. Please check if yave you have signed using your current client credetianls in your excel workbook.

 

Thanks,

Jai

jvanveelen's avatar
jvanveelen
Regular Visitor
1 year ago

these settings are correct. 

It looks when from for example excel you open the analyse to excel that it's not possible to connect to the model. I see the workspaces. i'm unable to connect to the on premise gateway, or live connection. 
Could it be also a license problem perhaps?