cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bclassen
Frequent Visitor

Running Reports Using Publisher for Excel

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.

0 REPLIES 0

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors