Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have been struggling quite a bit lately with my refreshes failing, is it possible that having different datasets refresh too close to each other could cause this? If it makes a difference, everything is being pulled from Excel and there are files that present in multiple datasets.
Thanks!!
Jim
Solved! Go to Solution.
Hi @Jim_
Is the error a timeout error?
And are you using the Personal On-Premise Data Gateway, or the Enterprise On-Premise Data Gateway?
Have you got the latest version installed?
I would suggest first testing the refresh manually, by using the Refresh Now option from the dataset. Wait for that to complete and see how long it takes.
Only once it can refresh successfully manually would I then look into scheduling the refresh.
Also remember that with Power BI Pro, there are only 8 refreshes a day, or 48 with Power BI Premium.
If it is still failing, I would then look into where you have got the Gateway installed.
Ensure that you have got enough CPUs (As I have found when processing Excel files, if there are a lot of applied steps in the Query Editor, it will consume almost all the CPUs).
Also ensure that you have got enough memory, as all the Query Editor steps are applied where the Gateway is installed.
And finally ensure that there is enough bandwidth, with a consistant connection to upload the data to the Power BI Service.
Hi @Jim_
Is the error a timeout error?
And are you using the Personal On-Premise Data Gateway, or the Enterprise On-Premise Data Gateway?
Have you got the latest version installed?
I would suggest first testing the refresh manually, by using the Refresh Now option from the dataset. Wait for that to complete and see how long it takes.
Only once it can refresh successfully manually would I then look into scheduling the refresh.
Also remember that with Power BI Pro, there are only 8 refreshes a day, or 48 with Power BI Premium.
If it is still failing, I would then look into where you have got the Gateway installed.
Ensure that you have got enough CPUs (As I have found when processing Excel files, if there are a lot of applied steps in the Query Editor, it will consume almost all the CPUs).
Also ensure that you have got enough memory, as all the Query Editor steps are applied where the Gateway is installed.
And finally ensure that there is enough bandwidth, with a consistant connection to upload the data to the Power BI Service.
@GilbertQ Thank you for the input. I do have a substantial amount work being done in the query editor. Although these files previously had updated reliably and there have been no changes to the query editor, there may have been some changes to the server that the personal gateway lives on.
I will go through the query editor steps and see what can be done in DAX vs M to reduce the load on the server.