I'm trying to build a report in PowerBI to show the following columns:
- Posting Date
- G/L #
- Cost Center (ShortcutDimension 3)
- Amount
- Budget amount
However, since it's not a global dimension and I do not plan on changing it, what's the best method for me to extract this data?
What are my options? Are the limited?
Thank you.