Performance issue in Power BI Service portal

[Anonymous]

Hi All,

We have created the Power BI Report and Published over to the Power BI Service portal.

In this report, We have to use the Table visual which displays the details about Sales Summary, In this sales summary Report, we have used two calculated measures depend on Date slicer i.e, % Change and Last Sale(Depend on period Selected).

The problem is when we access this report in Power BI desktop it works fine, but when we published over to the Power BI Service it takes a very long time to load the visuals that are the performance issue, and then shows the below Error message. If we minimize the slicer selection then it displays slowly, but cant displays when we select all fields in the slicer.

Please suggest any solution.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I believe you can refer to these similar posts:
https://community.powerbi.com/t5/Desktop/Can-t-display-this-Visual-after-publish/m-p/415284 

https://community.powerbi.com/t5/Service/Can-t-display-the-visual-Error/td-p/259107 

[Anonymous]

Hi,

I face this problem before.. Most probably is due to myworkspace(shared capacity) not able to handle the report data size.

There is limitation using shared capacity

I will suggest to try below

1. Try to use import method over live connection
2. Reduce data size by filter out unwanted data and remove all unused column or try this best pratices.
3. If above is not option for you, upgrade workspace to premium capacity

Hope it help.

[Anonymous]

Hi @Anonymous,

Thank you for the quick reply.

We are using the Azure Blob to import the data, so can't use a live connection.

and thank you for the third solution for Upgrading Workspace, we will work on it.

Thanks.