Things that make Power BI jobs take a long time, or Estimating: A Checklist
When estimating a Power BI job, some things could blow up the estimate disproportionately.
Doing Things That Power BI Is Not Good At
Power BI is generally good at what it does. When it's pushed to do what it's not designed to do, it can certainly do it, but costs will be paid either in development time or maintenace time.
Here are some things that Power BI is not good at:
- UI transitions
- Custom visuals
Complex RLS
Complex rules for row-level security will blow up development time in the testing phase. In order to test a set of RLS rules, the report needs to be published to the workspace, and then the security roles need to be tested one by one. This could take time.
Time Intelligence
Especially if it has to be written in DAX.
A data set that takes a long time to refresh
This speaks for itself. If the data set is either too big or inefficient, this hampers development.
After Care
There are an unestimable number of hours after a project in launched for little things that users will notice, which needs to be fixed.
Other things
Power BI Pro
The account that will eventually take over will need a Power BI Pro license.
All users will need a Power BI Pro license.