Adaptive Planning API - Switch version with API connector

[YDG]

Recently I figured out how to export Adaptive Planning data into Power BI using the API. One feature I'd like to develop is the ability to switch versions (assuming we have a budget version and a forecast version of opex).

I have tried to create a parameter with a list of version names. If I replace the version name in the query with the parameters name, there is no error in the query, but it can not successfully return any value. I am curious if anyone has solved problem. Thanks!

[YDG]

Solved!

[lbendlin]

Sounds like a reasonable approach. Can you show some sample Power Query?