1

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.

Improve this question

1 Answer 1

Reset to default
0

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:

enter image description here

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks, I'm aware of this possibility but I need to work on Live Connection actually.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.