Current pain: when adding a report (and data set) that rely on on-premise data sources, PowerBI assumes that a personal gateway will be used. This is not often correct. However, in order to make the dataset use an Enterprise Gateway, one has to be configured with matching data sources. To do this one needs to inventory data sources from the dataset and then create them (or add missing ones) to an enterprise gateway. It is painful today to determine what sources are missing (especially if something is misspelled slightly) and this is critical to ensure that the gateway can be used.
Desired: a prompt from the dataset configuration page that would list data sources used in the dataset, gateways that the user has access to that match some/all of the data sources.
Desired 2: a prompt that would automatically add the missing data sources to a chosen gateway prompting to enter credentials and other details OR directing to add that information on the data gateway configuration page.
- Comments (1)
RE: Enterprise Gateway - adding new data sources
'+2 That are good ideas and would make life easier!