Forum Discussion

ohurtado's avatar
ohurtado
Frequent Visitor
2 years ago

SDMX skip test connection not possible?

Hi, trying to connect to a several sources in Eurostat through SDMX connector. Everything works perfectly in Desktop, however when going to the service, some queries start to fail. I have narrowed it down to the way the Eurostat API works, for some the test connection will fail when it is sent without parameters, for some it will come back with an error. Is there a way to "Skip test connection" for SDMX? The option is not available under the "Edit credentials button".

 

As an example, this is an SDMX URL that works fine both in Desktop and Service:

SDMX.Contents("https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/prc_hicp_midx/M.I15.CP00.EA19/?format=SDMX-CSV&startPeriod=2010-01", "Show codes and labels", null) -> if you take parameters out, the query still works.

 

An this is an example of a query that works in Desktop but fails in the service:

SDMX.Contents("https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/sts_inppd_m/M.PRIN.MIG_ING.NSA.I15.EA19/?format=SDMX-CSV&startPeriod=2010-01", "Show codes and labels", null) -> without the parameters afer the ?, the query returns an error, therefore the test connection is failing.

 

Any ideas how to force a skip test connection on the second one?

 

Best regards,

Oscar

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ohurtado ,

     

    If your data source is on-premises data source, please update gateway to the latest version. Please see announcement below:

    https://powerbi.microsoft.com/en-us/blog/skip-test-connection-for-on-premises-and-cloud-data-sources...

     

    However, it seems like that some cloud source are not supported currently. The workaround is not to use the root url, you can use web.content to contain your credentials like access token.

     

    Or you can try changing the URL to include a parameter that allows skipping the test connection. For example, append `?skipTestConnection=true` to your URL.

     

    Power BI Service does not support calls to the Web.Contents-function if it does not know what URL to call to. So you can move the URL declaration directly into the Web.Contents-call.

    Please see announcement below: Use missing Skip Test Connection for Scheduled Refresh in Power BI | by Martijn Lentink | Medium

     

    Best Regards,

    Neeko Tang

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

    • ohurtado's avatar
      ohurtado
      Frequent Visitor
      2 years ago

      HI, Anonymous  thanks for the answer but it does not seem to solve the problem. The article is very old and not specifically related to the SDMX issue. Other web connectors have an option to "skip test connection" but not the SDMX one... 

      appending something to the URL is not the solution in my view as the test connection skipping issue is on powerbi service and not on the receiving API...
      Any other ideas?

  • fmasson's avatar
    fmasson
    New Member
    2 years ago

    Hi Oscar,

     

    Have you found a way to solve the problem ?

    I'm in the same situation.
    Let me know

     

    Regards

    • ohurtado's avatar
      ohurtado
      Frequent Visitor
      2 years ago

      Not really, but the API owner did some changes and the SDMX call without parameters is not returning errors anymore for my specific queries which indirectly resolved the problem.