Forum Discussion

nirs's avatar
nirs
New Member
8 years ago
Solved

Power query - column name in source json are changin

hi,   first post here, wanted to thank for the chance to do it   im pretty new to power query but found it to do exactly what we need here - basically we are building dashboard for campaign stats...
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    nirs

     

    According to your description, you already get data from API into Excel workbook. Now we want to dynamically select item then expand the corresponding records. Right? 

     

    In this scenario, you can retrieve the list of all user campaigns first. Convert it into a list. 

     

     

    Then you can create a query parameter with that list. 

     

     

    Now you can use Query Parameter to filter rows, and then expand the corresponding records. Please refer to link below: 

     

    POWER BI DESKTOP QUERY PARAMETERS, PART 1

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

nirs

 

According to your description, you already get data from API into Excel workbook. Now we want to dynamically select item then expand the corresponding records. Right? 

 

In this scenario, you can retrieve the list of all user campaigns first. Convert it into a list. 

 

 

Then you can create a query parameter with that list. 

 

 

Now you can use Query Parameter to filter rows, and then expand the corresponding records. Please refer to link below: 

 

POWER BI DESKTOP QUERY PARAMETERS, PART 1

 

Regards,

nirs's avatar
nirs
New Member
8 years ago

Many many thanks

 

always good to learn something new