Would you mind sharing the data of tables in your PBIX file? I make a test using the sample data you post but can't reproduce your issue. Are you able to get same issue when using the sample data? And do you use the "Export data" option in Power BI Desktop or Power BI Service?
Community Support Team _ Lydia Zhang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.