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