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

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

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Reporting Process Improvements with Power BI Pro?

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Reporting Process Improvements with Power BI Pro?

@FatDaddy - 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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IV
Super User IV

Re: Reporting Process Improvements with Power BI Pro?

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!