Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am wondering if I could get some assistance in finalizing some projects in which I am transitioning reports processes traditionally run using Macro-enabled VBA-based workbooks to PowerBI.
Eventually we will be transitioning to using PowerBI service to deliver finalized reports but I have been advised that during this transition phase I am to continue using Excel as the final deliverable. As such, I have built the PowerBI to run the requisitie data, published it to PowerBI cloud, imported the data into excel using the Publisher add-on, and built the graphs/charts that mimic the existing report.
What I would like to be able to do now is have an automated process whereby the "Market" filter I have on each of the graphs and charts is cycled through and a new excel workbook is created for each of the markets available in the filter.
So for instance I have 6 sheets on my template and 20 markets. I would like, in the end, 20 new Excel workbooks for each of those markets each with the 6 sheets I have on the template.
Can VBA do this? Is there a better way? I would like to remove as much manual effort as possible in the creation of these reports.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |