Performance report

[IrinaChivu]

Hi, 

I have a power bi report which has 3 different sources: Azure Analytics (direct query), Adobe Analytics (import) and some flat files (share point). 

The problem is that the refresh is taking more than 10 minutes and usually crashes and when I tried to publish the report all matrixes (which contains around 30 measures) can't be displayd. 

Any idea why this is happining and how can be fixed?

Thank you

[v-yanjiang-msft · Accepted solution]

Hi @IrinaChivu ,

According to your description, in my understanding, "the refresh is taking more than 10 minutes and usually crashes" happend in Desktop and "all matrixes can't be displayd" happend in Service.

In Desktop,  If the data model is very complex or the size of dataset is very large, it will cause timeout error., so please try to optimize the data model and reduce the size of dataset. In addition, you can also use Performance Analyzer to examine report element performance. After you have done the above steps, and the report still crash within the command timeout, you can also consider to increase the command timeout. Reference: How to set command timeout option.

In Service, as you have some data source that is concatenated via DirectQuery mode, you need a Power BI Gateway to query the data source after you publish the report.

There are five main steps for using a gateway:

1. Download and install the gateway on a local computer.
2. Configure the gateway based on your firewall and other network requirements.
3. Add gateway admins who can also manage and administer other network requirements.
4. Use the gateway to refresh an on-premises data source.
5. Troubleshoot issues with the gateway.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[arvindsingh802]

Create a dataflow for all the tables coming out of SharePoint and then use that dataflow as source in your dataset