Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This connector is owned and provided by the Statistical Information System Collaboration Community (SIS-CC).
Summary
| Item | Description |
|---|---|
| Release State | Beta |
| Products | Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2) |
| Authentication Types Supported | Anonymous |
| Function Reference Documentation | — |
Prerequisites
Before you get started, make sure you've properly configured the URL from the service provider’s API. The exact process here will depend on the service provider.
Supported capabilities
Import of SDMX-CSV 2.1 format. Other formats aren't supported.
Connect from Power Query Desktop
To connect to SDMX Web Service data:
Select Get Data from the Home ribbon in Power BI Desktop. Select All from the categories on the left, and then select SIS-CC SDMX. Then select Connect.
Fill in the parameters:
- In the Data query URL, enter an SDMX REST data query URL (the web service must support the SDMX-CSV format).
- In Display format, select one of the options:
- Show codes and labels; example: FREQ: Frequency
- Show codes; example: FREQ
- Show labels; example: Frequency
- Optionally, enter a language preference in Label language preference using an IETF BCP 47 tag
If this is the first time you’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
Select Load to import the data into Power BI, or Transform Data to edit the query in Power Query Editor where you can refine the query before loading into Power BI.
Limitations and considerations
This version of the connector doesn't support importing data formats SDMX-ML or SDMX-JSON.
Related content
If you want to submit a feature request or contribute to the open-source project, then go to the Gitlab project site.