Forum Discussion
Power BI reports data connect with REST API and reload data on Refresh dashboard.
But Thats the recommendation but is there any work around to get the data from API using slicer value?
because I am wondering that there is a option for direct query where we can pass the slicer value using R.
There should be some workaround where we can pass the slicer value to the API. if anyone know how to crack this pls comment OR lets solve this togther.
Hi Jaswinder, the way I have solved this problem has been to use a parameter and pass that to the PowerQuery. I realise that this is a less than perfect solution. To break the problem down into it's components, you have the slicer but no way to pass the slicer selected value from DAX, the presentation layer, to PowerQuery, the data layer. Parameters are also available in the model as what-if parameters, which is closer to what you need, but then they are not available to Power Query. At least I can't work out how to do that. On the positive side it is possible to do what you want in Excel Power Query by accessing the worksheet from PowerQuery. Another way might be to put the slicer on a visual that can update a stored value outside of the PowerBI system and then retrieve that value using Power Query