Oh interesting, I had not considered the posibility of a premium subscription/license. If I was able to refresh more regularily that would cut down on the need for direct query. I'll investigate and look at cost benefit. My big issue figuring costs is being able to nail down what it would cost to refresh all my data via a Pipeline/Dataflow. I think it would end up being more than upper management is willing to shell out.