Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Running Reports Using Publisher for Excel



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.

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors