There should be a button in the report and dashboard for on demand dataset refresh.
Agree. This is the single most annoying lack in Power BI. Please add the ability for report viewers (that don't subscribe to Power BI service) to refresh the dataset at will, preferable from within the report itself.
