Forum Discussion
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...
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,
Many many thanks
always good to learn something new
