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.
Hi
My report's dataset schedule refresh is taking too much of time. sometimes it is more than 5 hours and failed.
I am processing 150 csv files and getting 3 tables. example table A, B & C. Table A processed 100 files and Table B & C processed 25 files respectively and then Table A getting few columns from B & C tables so using merge transformation.
This whole setup is taking more than 2 hours to refresh and maximum of 5 hours. How to improve the performance?
Thanks
Hi Hari,
Can you answer these..
What is the time it takes when you refresh it from the Desktop ?
Are your files in On Premise or in the cloud/ Online (could be Blob / Sharepoint Folder / One drive) ?
Is your workspace premium or shared?
Can you check what is the size of your pbix file?
Thanks,
Nishanth.
Hi, @rhariharaneee2
Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, It is suggested to consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.
For further information, you may refer to the following link.
https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |