Issue while loading Visual in power bi page through Direct Query

[jatneerjat]

Hi,

We have 4 tabs in Power BI report and all pages are very slow whenever we open the report,usually it takes around 1 min to load for many visuals,the data source is cube and we are using direct query.

we are using some Stacked column chart and Line chart visuals which shows 28 data points. For each data point we are calculating rolling period for last 28 days so if we are showing data from 01/05/2018 to 01/06/2018 then for 01/05/2018 it shows data for 03/04/2018 and so on.

So how can we make visuals load faster?

Thanks

[rafaelmpsantos]

You need to use import mode, only If you have a very big dataset in this case the best way is to use report server.