This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 96%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Hi,
we are trying to connect Azure SQl database with azure Analysis services, but the data's are not connecting live. Is there any way to connect it live and i am using development pricing tier, is it needed to upgrade for live connection?
Thanks,
Hamna K S
Can you make sure that your Azure SQL Database firewall settings allow connections from Azure Analysis Services ?You need to add the IP addresses of Azure Analysis Services to the allow list of the Azure SQL Database firewall or by simply enabling "Allow Azure services and resources to access this server".
Hi Amira,
Thanks for your replay.
I had already enabled it.
I want Azure Analysis Services to access all the data's in Azure Sql database in real-time or as scheduled refresh.
or is there a way to create database in Azure Analysis Services?
Thanks,
Hamna K S
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 93%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Hi Amira,
your answers were very helpful.
i have a query regarding this.
what are the process to "Set the Web service URL to your Azure Analysis Services endpoint".
Regards,
Hamna
Hello Can you validate the answer ? Then create another question regarding your new request.