How to stop enumeration error in power query

[Anonymous]

Hi,

I've created an overview page for the CI initiatives we are doing (see below), however in Power Query the way I have set it up is that the Quick Wins/Local Projects are only those completed from this month. And the Last Month's Quick Win/Local Project is obviously last months completed CI's, and then to find the trend, I subtract the last month by the current month to find the difference. If no CI has been completed for this current month, then the overview sends the error message below because there are no CI's listed in that table, and from this, it then won't update any of the other metrics because that one data file can't be refreshed. Is there any way to make sure the others load even if that one does not? Thanks in advance

[Anonymous]

Hi @Anonymous ,

You may check if there are some changes for the connection information, such as file path ,authentication, connect encryption.

Plaease kindly refer to:

ERROR WHEN CHANGING DATA SOURCE

Load was cancelled by an error in loading a previous table

Load was cancelled by an error in loading a previous table

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.