Forum Discussion
Import Data from OECD website
Please try this URL instead: https://stats.oecd.org/SDMX-JSON/data/CSPCUBE/all?startTime=2011&endTime=2015&dimensionAtObservation=allDimensions
... it looks that omitting all the filter criteria works.
Hi junaidfrq
You may try to use On-premises data gateway to refresh the data. Here is the document for you.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
Regards,
Cherie
Hi Cherie,
Thank you for a great workaround.
Unfortunately, the client requires the data to be refreshed directly from the website (https://stats.oecd.org/) and does not prefer using a bridge.
This is definitely an addition to my knowledge and will keep in mind for future use.
Thanks again,
Junaid
Hi Junaid,
unfortunately the API limits the length of the URL to max. 1000 characters: https://data.oecd.org/api/sdmx-json-documentation/
Please try this URL instead: https://stats.oecd.org/SDMX-JSON/data/CSPCUBE/all?startTime=2011&endTime=2015&dimensionAtObservation=allDimensions
... it looks that omitting all the filter criteria works.
