Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I would like to confirm if my understanding on the power Bi cache is correct:
1. Power BI (service) maintains cache on a dashboard level for tiles. Does it do the same for reports too?
2. Is the cache shared beween all the users all over the world ( suppose no row level security is applied) ?
3. Is the cache maintained for any number of selectons a users makes?
Thanks in advance
Hi SwayamSelf,
Do you mean the cache refresh in dashboard? You can set cache refresh which will automactically refresh data without refreshing the browser in a configured interval such as 15min. Unfortunately, report doesn't have such setting, the schedule refresh for report is achieve data from data source, not from cache. In addtion, there's no relationship between dashboard cache and number of selections by user.
Regards,
Jimmy Tao
Thanks @v-yuta-msft, for your reply.
I am not mentioning about cache refresh.
I am tring to understand cache retainment for reports.
So the scenarion is this:
Suppose I would like to share a PBI report with one page only with my users . Please note I am sharing report not dashboard with tiles.
First time the user opens the report its takes 10 secs to fully load.
Is it possible that the next time the user opens (within 15 mins) the report will take <10 secs ?
This will only be possible if the report has stored cache for the first time load.
Also if another user changes the filter selection from A to B suppose, will the cache be stored i this case too?
Hi,
Did you get the solution for this? I am also looking for something similar!!
Regards,
Shreyas
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
36 | |
21 | |
19 | |
17 | |
10 |
User | Count |
---|---|
35 | |
34 | |
32 | |
19 | |
16 |