Forum Discussion
YDG
3 years agoFrequent Visitor
Adaptive Planning API - Switch version with API connector
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!
3 Replies
- lbendlinSuper User
Sounds like a reasonable approach. Can you show some sample Power Query?
- YDGFrequent Visitor
Solved!
- Carlos_23486846Frequent Visitor
What was your solution? I'm looking to do this too.