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

mattiasdesmet's avatar
mattiasdesmet
Icon for Resolver II rankResolver II
1 year ago

Hi, could you provide some more concrete detail? The slicer acts on data in the model, and wouldn't determine what API to import. You can import all different APIs and potentially add a field from which API the data is coming, which is then used in the slicers. The import operation happens when the dataset is refreshed, not at slicer change time.