Forum Discussion
Refresh failed due to XML Analysis timeout
- 1 year ago
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 🙂
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 🙂