Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Team,
I have one PB Desktop report of 240 excel files which have uploaded from folder. Now added 160 more files in the same folder.
While refreshing the existing report keep on receiving the below message.
Can you please help how to correct it as size is huge so even small change refresh takes 6 hours.
Thanks and Regards,
Prashant
Error message "
Hi @PrashantA ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.
Best Regards,
Eyelyn Qin
Hi Eyelyn,
Sorry for delay in reply as was unwell, below is the new error came in after applying provided solution.
Can you please help
Thanks and Regards,
Prashant
Hi @PrashantA ,
First, based on the screenshot, the error occured when you try to apply all transformations did in Power Query.
Please try to resolve the issue through the following steps:
Second, I believe you can get more hints from these documents about how to optimize refresh speed:
1.Reduce the size of dataset or optimize the model of dataset
2. Use dataflow
3. Use Incremental Refresh
...
Optimization guide for Power BI - Power BI | Microsoft Docs
How to Use Dataflow to Make the Refresh of Power BI Solution FASTER! - RADACAD
https://medium.datadriveninvestor.com/my-dataset-is-taking-too-long-to-refresh-843fd8fd4a51
Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1. you have an error in your transforms. Only you can chase that down. For testing eliminate the 240 files that loaded correctly.
2. Disable loading of previews in the background. That will speed up your process somewhat.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |