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

Anonymous's avatar
Anonymous
Not applicable
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