Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
Anonymous
Not applicable

Reporting Process Improvements with Power BI Pro?

Hello everyone,

 

I am trying to get tips on how we can maximize our efficiency with our reporting process.

 

  1. Currently we use alteryx to do transformations with our data and spit out a giant csv before Power BI Desktop injest the data for our reporting. We have a standard template so we can just delete the current csv table and connect to a new one for a new report on different topics.

 

  1. We then publish the report to power BI Pro and send out access emails through the grant access feature.

 

  1. On a periodic basis we will update our power BI desktop file and republish. Then, we will send out update emails through regranting access to the same individuals.

 

A couple features that I was looking into with Power BI:

  1. Incremental refresh – it seems we don’t have to have power bi constantly load the entire set of data again but just the additional changes
  2. It seems that we don’t have to send update emails each time the data gets refreshed as there is a feature that you can turn on

If anyone can suggest other improvements It would be much appreciated.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
2 REPLIES 2
amitchandak
Super User
Super User
Greg_Deckler
Community Champion
Community Champion

@Anonymous - Couple things

  1. Not sure why you are using Alteryx, it is expensive and Power BI can do all of the transformations itself using Power Query, which is built into the Desktop or can be done in Dataflows
  2. Yes, if you had Power BI doing your data ingest, you could use incremental refresh to speed up your data refresh times
  3. Publish your PBIX to the Service once. Set automatic refresh, no need to republish and re-grant access every time. That sounds like you are doing a ton of work that you do not need to

A recent article of mine might help: https://community.powerbi.com/t5/Community-Blog/Power-BI-Usage-Models-in-Pictures/ba-p/1342820



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.