Please try with Restricted Author licensed role. It allows only Workbook authoring while restricting the access to create datasets, dataflows, and connections. However I agree with you that we need granular control over these permissions.

Dear OAC/FDI experts , Please upvote this idea. This will be gamechanger for OAC as a product.

Thankyou for upvoting. Requesting you to ask your team members to upvote as well.