https://daxformatter.azurewebsites.net/api/DaxTokenFormat/ is not reachable

[mariusgsandu]

Hello!

Looks like we can't reach https://daxformatter.azurewebsites.net/api/DaxTokenFormat/ from several "locations":

• Website: https://www.daxformatter.com/
• Github Runner
• DAX Studio/Tabular Editor

We've attempted multiple networks with the same output.
The website throws the following error when attempting to format EVALUATE { 1, 2, 3 }:

Service Unreachable
There could be a firewall or anti-virus blocking communication with the service used to format DAX queries. You can try to:
Enable requests made to https://daxformatter.azurewebsites.net on your firewall or anti-virus configuration. If you are in a company network, you might have to contact your system administrator.
Use the [Lite version](https://www.daxformatter.com/raw/), which does not require requests to an external service.

The github runners display the following output:

• 503 Server Error: Service Unavailable
• 502 Server Error: Bad Gateway

[marcosqlbi]

Please, can you provide the IP address(es) from which you are calling the service?
Thanks!

[mariusgsandu]

Heya,

Assuming https://daxformatter.azurewebsites.net can be found at 52.162.107.10, tracert outputs the following:

Tracing route to 52.162.107.10 over a maximum of 30 hops

  1     2 ms     2 ms    <1 ms  192.168.1.1 
  2     3 ms     4 ms     3 ms  192.168.0.1 
  3    16 ms    14 ms    12 ms  82-210-162-1.home.aster.pl [82.210.162.1] 
  4    12 ms    15 ms    12 ms  95.77.36.161 
  5    14 ms    16 ms    16 ms  136.255.248.202 
  6    15 ms    16 ms    15 ms  ae92-0.ier02.syd.ntwk.msn.net [104.44.37.57] 
  7    46 ms    74 ms    44 ms  ae22-0.rwa03.vie.ntwk.msn.net [104.44.230.249] 
  8     *        *        *     Request timed out.
  9     *        *        *     Request timed out.
 10     *        *        *     Request timed out.
 11     *        *        *     Request timed out.
 12     *        *        *     Request timed out.
 13     *        *        *     Request timed out.
 14     *        *        *     Request timed out.
 15   157 ms   154 ms   154 ms  104.44.53.244 
 16     *        *        *     Request timed out.
 17     *        *        *     Request timed out.
 18     *        *        *     Request timed out.
 19     *        *        *     Request timed out.
 20   160 ms   156 ms   153 ms  52.162.107.10

Looks like it is intermittent, got it working every now and then, but still fails often;

Thank you!

[marcosqlbi]

There are issues with the Azure hosting; we opened a ticket with Microsoft support, and it seems to be an infrastructure problem that does not depend on our implementation or deployment.
What is happening is that a few requests are served, many others are blocked. It does not depend on the IP source, apparently.
I'll keep you posted!

[marcosqlbi]

Update: The service is improving, but we observed other disruptions today. The ticket is open with Microsoft support, but the case is still open.

[marcosqlbi]

After 3 full days with full availability, I think we can close the issue.
Thank you for reporting!

[dkay-TCN]

After 3 full days with full availability, I think we can close the issue. Thank you for reporting!

This is failing intermittently again FYI

[marcosqlbi]

I don't have any evidence in our Telemetry, we have a 100% availability in the last 72 house.
Please can you provide more details about the error and the source IP?