Hi @Declan_McCarthy,
Based on looking into previous posts with similar behavior, I would say this seems to be a current limitation with Direct Query datasets specifically. I would definitely recommend looking into the solution mentioned in this post, as it might help you for your use case. If not, please let us know and we can definitely see if there are other solutions/workarounds possible.
Thank you!