Power BI Premium Reports And Refreshes - Actions to take?

[sky_blue_7]

Dear Power BI Experts.

I'm new to powerBI and trying to get around how refreshes work. I've a PRO license at my workplace.

I've come accross this post and really confused how this used as day to day user. I've installed the Premium Capacity Metrics app but it does not much info as I've not published reports or datasets. If I'm a PRO user, what this app can show? how my reports are consuming he resources? Or this is mainly for server side admins?

Please delete if it's not within the right post area.

[sky_blue_7]

Thanks much Stuart @Burningsuit. Now it makes sense. As a report author, what are some areas that we can focus that will drive better user experience i.e-faster report refresh+interaction with the dashboard. If you're aware of any resources, that would be a treat!

[Burningsuit]

Optimising reports?

Well firstly, don't use DirectQuery. After that it's making sure you have a good underlying datamodel (Star Schema), not one big flat table of data. Not creating loads of calculated columns but using measures instead.

There's lots of online resources, obviously the Microsoft documentation is one place to start.

Optimization guide for Power BI - Power BI | Microsoft Docs

I also highly rate the "Guy in a cube" youtube channel, watch this first before going  through the documentation. (57) Why is Power BI SLOW - YouTube

Hope this helps

Stuart

[Burningsuit · Accepted solution]

Hi @sky_blue_7 

Welcome to the wonderful world of Power BI !

That post and app really have no relevance to a Pro licence user. Pro users share the capacity Microsoft provides. They're just one of many users of Microsofts's cloud service. That is why Pro is limited in some aspects, number of automated refreshes, size of Dataset etc. so that no one Pro licence hogs all the Capacity and slows the others down. Pro licence users have no say in how much capacity they get to use. 

Premium Capacity licences however use a dedicated capacity Microsoft provide. (I think of it as renting my own Server in the cloud) So an admin can manage that capacity and allocate it to various services etc. - which is what that post is about. Unless you get a Premium Capacity licence, that post and app are irrelevant.

Hope that helps

Stuart