Working with cube data - refreshing

[Anonymous]

Hi all,

I am connected to a SSRS cube in my BI report, typically my team uses the live connection to show up to date data. I am wondering if rather then connecting "live" would it be okay to import the data and set the report to auto refresh every hour in PBI workspace. Will importing data from the cube then refreshing it work? is there a special way to update "cube" connected data. 

Thank you

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

First of all, you have to be clear about the features and limitations of import and live connection mode, so you can choose the suitable mode according to your own needs and scenarios. The following two blogs explain this information in detail and you can read them to learn more.

Power BI – Live connection vs. Import, comparison and limitations

DirectQuery, Live Connection or Import Data? Tough Decision!

Connect to SSAS
In addition, Power BI does not yet support switching from live connect mode to import mode directly, which means you need to recreate the measures, visuals etc. involved in the report... The following is one similar idea shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature .

Support switching SSAS connect model from "Connect Live" to "Import"

Best Regards