Cache management Power BI Services and Azure Analysis Services cube
Hello,
I'm publishing a Power BI report with an Azure Analysis Services cube as source. The thing is that when I open it for the first time in PBI Services, all the visuals and measures are loading which is fine. I'm waiting till the end but then if I close the report and come back later, all the measures will load again and it really is a problem for my customers. I know I can schedule a cache refresh but even if I do so, the reports will still refresh every time I open them.
Any idea to solve this ?
Thanks a lot.
azure refresh powerbi azure-analysis-services asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
add a comment |
Hello,
I'm publishing a Power BI report with an Azure Analysis Services cube as source. The thing is that when I open it for the first time in PBI Services, all the visuals and measures are loading which is fine. I'm waiting till the end but then if I close the report and come back later, all the measures will load again and it really is a problem for my customers. I know I can schedule a cache refresh but even if I do so, the reports will still refresh every time I open them.
Any idea to solve this ?
Thanks a lot.
azure refresh powerbi azure-analysis-services asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
add a comment |
Hello,
I'm publishing a Power BI report with an Azure Analysis Services cube as source. The thing is that when I open it for the first time in PBI Services, all the visuals and measures are loading which is fine. I'm waiting till the end but then if I close the report and come back later, all the measures will load again and it really is a problem for my customers. I know I can schedule a cache refresh but even if I do so, the reports will still refresh every time I open them.
Any idea to solve this ?
Thanks a lot.
azure refresh powerbi azure-analysis-services asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
Hello,
I'm publishing a Power BI report with an Azure Analysis Services cube as source. The thing is that when I open it for the first time in PBI Services, all the visuals and measures are loading which is fine. I'm waiting till the end but then if I close the report and come back later, all the measures will load again and it really is a problem for my customers. I know I can schedule a cache refresh but even if I do so, the reports will still refresh every time I open them.
Any idea to solve this ?
Thanks a lot.
azure refresh powerbi azure-analysis-services azure refresh powerbi azure-analysis-services asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
asked Nov 26 '18 at 8:32
Mathieu RicourMathieu Ricour
203215
203215
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
In case you are using live connection, switching to imported should speed things up. This means that when getting the data from SSAS, you should select Import option:
When importing data, your report will not work with the "live" data, but with a cached copy. This will speed things up, but you will need to schedule a refresh. However, with SSAS you probably do not work with live data too. Usually there is a nightly ETL, which will refresh the data in your model. So you may want to schedule a refresh of your dataset at appropriate time, after the refresh of SSAS is completed.
You can read more about Live connection vs. Import here.
Unfortunately, I don't think you can switch this option for existing reports. There is an idea for which you can vote, though. So you may need to re-create your report to do that.
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
Thanks, I'm aware of this possibility but I need to work on Live Connection actually.
– Mathieu Ricour
Nov 26 '18 at 9:50
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477234%2fcache-management-power-bi-services-and-azure-analysis-services-cube%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In case you are using live connection, switching to imported should speed things up. This means that when getting the data from SSAS, you should select Import option:
When importing data, your report will not work with the "live" data, but with a cached copy. This will speed things up, but you will need to schedule a refresh. However, with SSAS you probably do not work with live data too. Usually there is a nightly ETL, which will refresh the data in your model. So you may want to schedule a refresh of your dataset at appropriate time, after the refresh of SSAS is completed.
You can read more about Live connection vs. Import here.
Unfortunately, I don't think you can switch this option for existing reports. There is an idea for which you can vote, though. So you may need to re-create your report to do that.
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
Thanks, I'm aware of this possibility but I need to work on Live Connection actually.
– Mathieu Ricour
Nov 26 '18 at 9:50
add a comment |
In case you are using live connection, switching to imported should speed things up. This means that when getting the data from SSAS, you should select Import option:
When importing data, your report will not work with the "live" data, but with a cached copy. This will speed things up, but you will need to schedule a refresh. However, with SSAS you probably do not work with live data too. Usually there is a nightly ETL, which will refresh the data in your model. So you may want to schedule a refresh of your dataset at appropriate time, after the refresh of SSAS is completed.
You can read more about Live connection vs. Import here.
Unfortunately, I don't think you can switch this option for existing reports. There is an idea for which you can vote, though. So you may need to re-create your report to do that.
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
Thanks, I'm aware of this possibility but I need to work on Live Connection actually.
– Mathieu Ricour
Nov 26 '18 at 9:50
add a comment |
In case you are using live connection, switching to imported should speed things up. This means that when getting the data from SSAS, you should select Import option:
When importing data, your report will not work with the "live" data, but with a cached copy. This will speed things up, but you will need to schedule a refresh. However, with SSAS you probably do not work with live data too. Usually there is a nightly ETL, which will refresh the data in your model. So you may want to schedule a refresh of your dataset at appropriate time, after the refresh of SSAS is completed.
You can read more about Live connection vs. Import here.
Unfortunately, I don't think you can switch this option for existing reports. There is an idea for which you can vote, though. So you may need to re-create your report to do that.
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
In case you are using live connection, switching to imported should speed things up. This means that when getting the data from SSAS, you should select Import option:
When importing data, your report will not work with the "live" data, but with a cached copy. This will speed things up, but you will need to schedule a refresh. However, with SSAS you probably do not work with live data too. Usually there is a nightly ETL, which will refresh the data in your model. So you may want to schedule a refresh of your dataset at appropriate time, after the refresh of SSAS is completed.
You can read more about Live connection vs. Import here.
Unfortunately, I don't think you can switch this option for existing reports. There is an idea for which you can vote, though. So you may need to re-create your report to do that.
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
answered Nov 26 '18 at 9:11
Andrey NikolovAndrey Nikolov
4,3333922
4,3333922
Thanks, I'm aware of this possibility but I need to work on Live Connection actually.
– Mathieu Ricour
Nov 26 '18 at 9:50
add a comment |
Thanks, I'm aware of this possibility but I need to work on Live Connection actually.
– Mathieu Ricour
Nov 26 '18 at 9:50
Thanks, I'm aware of this possibility but I need to work on Live Connection actually.
– Mathieu Ricour
Nov 26 '18 at 9:50
Thanks, I'm aware of this possibility but I need to work on Live Connection actually.
– Mathieu Ricour
Nov 26 '18 at 9:50
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477234%2fcache-management-power-bi-services-and-azure-analysis-services-cube%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
