Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Is there a way to set default gateway "maps to" value and schedule in an easier way?

We have dozens of reports and expect to have close to a thousand across multiple projects, few thousands if you include pipelines.

One of the biggest annoyances is the fact that we need to go into the datasets configuration for each dataset in a workspace, expand Gateway connection and then set the Maps to value for every single dataset that points to our server.

The same goes for Scheduled refresh, which must be configured manually for every single dataset.



  1. How can we default the Maps to value?
  2. How can we default the Scheduled refresh?
  3. Can we create a custom schedule and apply it to multiple reports?
    • Right now we have to manually go from one report to the next and Add another time every half hour during our business hours
    • We do this across over a dozen reports at the moment, but expect this to increase dramatically as I mentioned.


If no defaulting is possible, is this in the feature pipeline?

Dataset settings are quite manual right now and many of them can be applied a settings template at least... Would save a lot of time.

Makes managing these reports unmanageable as we scale up.

Super User
Super User

Hi @ctoscher ,


I do not believe that there is any way to default this.  I think you should create an idea and let us know about it so that we can vote for it.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors