Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PBI Refresh Fails - with error Data source error:The XML for Analysis request timed

Data source error: The XML for Analysis request timed out before it was completed. Timeout value: 18000 sec.  I already have a Premium per user  set up for the workspace.     
General Comment
Need Help
collinq's avatar
collinq
Super User
3 years ago

HI Anonymous ,

 

There could be a few reasons:

You may have exceeded the capacity limit, or the node level limit.  You might have too many reports refreshing simultaneously.  You may need to increase the timeout.  Your data source itself might not be feeding your query fast enough.

 

Once you check all of those things out you can start the more painful (in my mind) work of breaking up your queries into smaller chunks and run them separately.  Or, you could implement incremental refresh and do that from the beginning with partitions.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for quick response please find my question  below for each case you just mention :

  1. You may have exceeded the capacity limit or the node level limit – How to check this ??
  2. You might have too many reports refreshing simultaneously – I have only one report in my workspace.
  3. You may need to increase the timeout. – How do I do this ?
  4. Your data source itself might not be feeding your query fast enough -   how to check and remediate.
  • collinq's avatar
    collinq
    Super User
    3 years ago

    Hey Anonymous ,

     

    1.  In the Admin Portal, you can review the Capacity Settings to see the levels that they are set to.  You can also review the Gateway and the setting for it - and (3) that is where the timeout resides.  Also, you can ask your Gateway Administrator to look at the load on the server on both the RAM and the CPU.

    2. Well - this means about all reports everywhere, not just your own workspace.  The Premium Capacity is sharing with everybody using it.  You might have many reports running at the same time.

    4. That is going to be a question for the person(s) managing your data source.  They need to tell you the throughput.  Or, you can do a Fiddler trace on the network to see the speed.