Forum Discussion
Help with parameter in dynamic query
I am very new to Power Bi.
I am trying to create a dashboard to display some data.
I have a query which fetches some data from an external API. Data looks like the following.
[
{
"name": "Bitcoin",
"code": "BTC",
},
{
"name": "XRP",
"code": "XRP",
},
{
"name": "ETHEREM",
"code": "ETH",
}
]
I have created a slicer.
Is it possible in Power Bi to create a parameter with the selection of the slicer?
I want to use the parameter value in another dynamic query to fetch data whenever the slicer value changes and display the result of the dynamic query.
Or
is it possible to fetch data from a different table based on the selection. I have a table with historic data of bitcoin, xrp, eth
Dynamic M Query parameters only work with Direct Query data sources. External APIs are always Import Mode data sources. So - not possible.
1 Reply
- lbendlinSuper User
Dynamic M Query parameters only work with Direct Query data sources. External APIs are always Import Mode data sources. So - not possible.