Just linked to a tabular model using embedded connection string to SSAS. I was able to select my dims and facts and drop them in the spots I wanted to. It wasn't hard at all and this was off of a tabular model. All the objects appeared including KPI's, etc.

I would think normal business users would have enough to play with if you build out the model correctly. If they need something like a unique count or some sort of condition aggregate you'll build that in DAX at the model level and the users will just grab the object as needed. Of course you'll rebuild and deploy.....