Forum Discussion

HFT's avatar
HFT
Icon for Helper I rankHelper I
1 year ago
Solved

Dynamic API call

I want to make the API call dynamic in import mode, to get the data in the power bi data model using a slicer. I tried to achieve that using the parameters, which i build them in power query, but can...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi HFT ,

     

    As far as I know this is not possible, the processing and cleaning of the data is done in PowerQuery. You need to import all the tables first and then create a Field parameter in the Desktop to dynamically switch the data source of the visual display.

     

     

    Here is my test and attached pbix file for your refernce.

    When I selected Date column of Table1, the visual showed data of Table1.

    When I selected Test1 column of Table2, the visual showed data of Table2.

     

     

     

    Best regards,

    Mengmeng Li

HFT's avatar
HFT
Icon for Helper I rankHelper I
1 year ago

Is there any workaround to make a dynamic API call based on slicer? I know we can make a parameter in Power Query and then bind a field to that parameter and link that field to a slicer. However, this is only supported in Direct Query mode and, from my understanding, APIs do not support Direct Query in Power BI. Is there any alternative solution to this such as using Power Automate/Flow or any other Microsoft/third-party services?