load report from cache ?? in powerbi service

[Anonymous]

hi

my users are feeling uncomfortable while using powerbi earlier we are using qlick . even when they apply the filters or open the report they are seeing the report like below for few seconds and then the values are being loaded . Is there any option to get the quickly on fly without taking even seconds of time . can anyone suggest any options on this?

[GilbertQ]

Hi there,

From your image above what represents those 18 images?

If you are unaware it would appear that having too many visuals on one page will require at the very least 18 queries to be run at once. And depending if that is DirectQuery or an Import mode it can take a while to run.

I would suggest either creating a starting page where you can sync the slicers across all the pages where the user first starts out and filters the data before going through to any other pages.

[Anonymous]

@GilbertQ : These are the advanced card visuals with the measures . currently i am using the import mode . I didn't understand the creation of sync scliers or landing page ?. can you please ellaborate the steps what you are saying

[GilbertQ]

Hi @Anonymous 

Here are more details

• Creating a landing page where the users start from.
  • In this landing page you create all the slicers that you users would want to slice or filter the report by.
  • When creating the slicers if you use the default slicers you can sync them across all the report pages.
  • Here is more information: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicers
• Once the users have used the slicers they can then navigate to the particular pages they are interested in.

I would also suggest ensuring that your data model is in a star schema and that the measures are written optimially so that they can return the results as quickly as possible (Should typically be less than 1-2 secs)

[Anonymous]

@GilbertQ : Yes this is in star schema and all the visuals are loaded soon like with in 5 mins of time . Creating  a landing page will be extra burden for the user this will definately not needed in my usecase . I just want to check if there any other options i can set at powerbi end which makes life easy . Like any caching options which i could have missed just want to know these

[GilbertQ]

Hi there,

If it is in a star schema are there a lot of unique values?

I would have a look at the measures to ensure that they are returning the data quickly?
Typically a chart should return the data almost instantly?