Forum Discussion
Passing slicer selection to REST API call in power query
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"
Dynamic M Query Parameters only work with Direct Query data sources. Your API isn't one.
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.
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.
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.
2 Replies
Dynamic M Query Parameters only work with Direct Query data sources. Your API isn't one.
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.
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.
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.