Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
YDG
Frequent 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 3
YDG
Frequent Visitor

Solved!

What was your solution? I'm looking to do this too.

lbendlin
Super User
Super User

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

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.