We are exposing header to community/ideas via header endpoint which are on different UI frameworks -->
The Australian government has made thousands of datasets available through their OpenData initiative. I'm playing with the following dataset:
I have created a Web Datasource based on this URL: airquality.des.qld.gov.au/v1/stations
-
This returns a JSON object listing all the air quality sensor stations.
-
I can converted the JSON to a table.
I'd like to make a subsequent call to the URL: airquality.des.qld.gov.au/v1/stations/{station_id}/parameters/measurements
-
As you can see, this takes the station_id from the previous URL as an input
-
It's going to return a dataset per station, which I'm happy to store in a single "measurements" table
I tried to create a parameter from the stations dataset and use it in the URL to obtain the measurements datasets, but that gave me a "please rebuild this data combination" error.
I am now trying to follow
but it's a little confusing.
Any help is appreciated.
I've run into this many times when using web service APIs
To get around this you'll likely have to encapsulate the data sources, at least maybe for stations, into a function
So maybe, GetStation () which just returns the JSON
The caller can convert the JSON into a list, then use this to adjust the URL to get the measurements
It is a pain, but it works. The following quote from the article below helped me find a solution when I encountered the same as you
"
Embedding or masking your Data Sources inside Functions
– this method will make your data sources not visible to the Data Privacy Levels at first, but you can tune your queries to define the data source at first and then apply a function."
https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/
I've run into this many times when using web service APIs
To get around this you'll likely have to encapsulate the data sources, at least maybe for stations, into a function
So maybe, GetStation () which just returns the JSON
The caller can convert the JSON into a list, then use this to adjust the URL to get the measurements
It is a pain, but it works. The following quote from the article below helped me find a solution when I encountered the same as you
"
Embedding or masking your Data Sources inside Functions
– this method will make your data sources not visible to the Data Privacy Levels at first, but you can tune your queries to define the data source at first and then apply a function."
https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/
Power BI September 2023 Update
Take a look at the September 2023 Power BI update to learn more.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Power Platform Conference-Power BI and Fabric Sessions
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.
We are exposing header to community/ideas via header endpoint which are on different UI frameworks -->
