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 |
|---|---|
| 55 | |
| 37 | |
| 23 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |