Forum Discussion
Refresh failed due to XML Analysis timeout
Hello everyone,
I have a power bi pro license, and my report is most of the time failing to refresh due to same error "XML time out 7200 sec.", therefore I have to update it manually from desktop app and publish it.
regardless of my efforts to fix it, I end up with same error which some other days it succeed to refresh by itself.
the dataset is collected from SharePoint folder and public API, with almost 2.5GB csv files when they are combined they make a table of 6M+ rows, can't group rows due to needs of users, and these csv files are daily changed with newer data,
the report size from DAX Studio is 485 MB, so I'm not need to pro license limit of 1GB
Thanks!
I may have found an alternative by using the Dataflow to run the query on my imported CSV files to prepare my tables on service instead of the app. this has made my refresh successful and less than 2 hours my current license limitation.
I want to thank you for helping me and suggeting solutions for my issue 🙂
4 Replies
The "XML Analysis Timeout" error usually occurs due to the large size of your dataset during refresh. Here are some solutions you can try:
- Optimize Data Model: Filter out unnecessary columns or rows in Power Query to reduce the size of the data before loading it into Power BI.
- Increase Timeout Setting: You can try increasing the timeout duration in the Power BI service settings to allow more time for the refresh process.
- Split Data into Smaller Tables: If possible, split the large dataset into smaller, manageable tables to avoid hitting refresh time limits.
- Scheduled Refresh: Schedule the refresh during off-peak hours when the system is less likely to face network or server issues.
- Use DirectQuery Mode: If applicable, switch to DirectQuery mode instead of importing large data, which can help bypass some refresh issues by querying the source directly.
Thanks but my current license doesn't allow to increase the Timeout, and I can't use the Direct Query as the Dataset are CSV files.
is there something esle I could do?
Pre-process data i.e. use Parquet format
Use Incremental Refresh.
Split large CSV files into smaller ones.
Consider Power BI Premium for better capacity.
I may have found an alternative by using the Dataflow to run the query on my imported CSV files to prepare my tables on service instead of the app. this has made my refresh successful and less than 2 hours my current license limitation.
I want to thank you for helping me and suggeting solutions for my issue 🙂
