Passing slicer selection to REST API call in power query

[girlwonder]

I have this slicer.

I want the end user to select a Currency Code from the slicer and then use that Currency Code in a REST API call in Power Query?

How do I add the Currency Code selected in this slicer to the end of this API call?

https://api.website.com/v2/exchange-rates?currency= ???

let
       exchange_rates_url = "https://api.website.com/v2/exchange-rates?currency={Currency Code}", //Web Url
   request_limit = "10000", //number represented by a string
   Source = Json.Document(Web.Contents(exchange_rates_url, [Query = [limit = request_limit]])),
    // number represented by a string
    data = Source[data],
    // number represented by a string
    rates = data[rates],
    #"Converted to Table" = Record.ToTable(rates)
in
    #"Converted to Table"

[lbendlin · Accepted solution]

Dynamic M Query Parameters only work with Direct Query data sources.  Your API isn't one.

[Anonymous · Accepted solution]

Hi @girlwonder 

As the @lbendlin  mentioned, if you want to use the dynmaic paramater, you need to make sure that your connection mode is direct query, such as SQL database and so on, they can be connected by Power BI Desktop with direct mode, You can refer to the following link about the dynamic paramater.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#prerequis...

If you want to change the paramater with the import mode, it only can be changed in power query or In data source settings in Power BI Service, You can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters#review-and-edit-parameter...

You can change the data source to the ones that support direct query mode. such as :

• SQL Server
• Azure SQL Database
• Azure Synapse Analytics (formerly SQL Data Warehouse)
• Oracle
• Teradata
• SAP HANA

Best Regards!

Yolo Zhu

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

[lbendlin · Accepted solution]

Dynamic M Query Parameters only work with Direct Query data sources.  Your API isn't one.