Share This Post

Power BI

SIS-CC-SDMX

sdmx

The new SIS-CC SDMX connector is released in this update.

SIS-CC SDMX connector allows us to easily query any public SDMX REST web service endpoint that supports the SDMX-CSV output format to analyze, visualize and share data from Power BI.  Statistical Data and Metadata exchange (SDMX) is an ISO international open standard adopted and used by statistical organizations (national, sub-national, regional, and international) for the production and dissemination of official statistics. This connector is an open-source project

In Oct 2021 Power BI team released a new connector sdmx connector and sdmx is basically a protocol that international organizations use to distribute data to open source community and some of the organizations that participate in this initiative are UNICEF, OECD, Chile international labor organization and many others.  So we will be able to get data from tons of resources and schedule refresh.

This connector is an sdmx csv connector so, you need to generate sdms csv query in this platform in order to pull data out of the box in Power BI.

Following are the steps to connect to SDMX Web Service data:

  1. Select Get Data from the Home tab in Power BI desktop. Select All, and then select SIS-CC SDMX. Then select connect.Power BI GetData window
  2. Fill in the parameters:
    • In the Data query URL, write SDMX REST data query URL (the web service must support the SDMX-CSV format).

    Here the sdms query is from Pacific Data Hub.

    • In Display format, select any of the options:

    Show codes and labels; example: FREQ: Frequency

    Show codes; example: FREQ

    Show codes; example: FREQ

    Show labels; example: Frequency

    Optionally, write language preference in Label language preference.

  3. If this is the first time we’re connecting to the REST web service in the previous step Data query URL, this authentication step is displayed. As the connection is Anonymous, select Connect.
  4. Select Load to import the data into Power BI, or Transform Data to edit the query in Power Query Editor where we can refine the query before loading into Power BI.
  5. After loading the data, we can create the innovative reports using the data in various visuals.

Stay tuned for further updates in SDMX connector, as if there is any other update on this connector then that will be reflected here also.

Other Posts by Author:

Prachi
Author: Prachi

Share This Post

Leave a Reply