Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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!
Solved!
What was your solution? I'm looking to do this too.
Sounds like a reasonable approach. Can you show some sample Power Query?
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 32 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 82 | |
| 66 | |
| 42 | |
| 27 | |
| 25 |