Data Gateway missing dataset

[C_Wilson]

Hi All,

I have a data gateway up and running and have configured many datasets. One of these data sets is a folder containing several Excel files.

I have a report that reads in the excel files and connects to Salesforce to produce a report. However when I go to schedule a refresh I get the message:

"You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway. "

It doesn't tell me what data sources or any further information. I don't understand why this is happening as I have all the data sets there in the folder.

Can anyone provide any way that I can understand this please?

Thanks,

Craig

[Seth_C_Bauer]

@C_Wilson When is the last time you updated the gateway? Also, this reads like you are not currently using the personal gateway. The Data Gateway (On Premises Data Gateway) does not support mixed mode datasets. (Online vs. On premises) -> Only the personal gateway does at this time.

[zelroberic]

Thanks Seth that was actually my problem don't know why it worked, but it did.

[C_Wilson]

Hi Eno,

The gateway has been updated to the September release. You are correct we are using the enterprise gateway as we are a large organisation. I am very surprised that this is not supported.

Can anyone comment on when the enterprise gateway will support this? This is extremely dispointing and a major blocker.

Thanks,

Craig

[v-huizhn-msft · Accepted solution]

Hi @C_Wilson,

Please keep your eyes on the following feature requests and vote them.

Addition of multiple Excel file data sources by folder/wildcard
Add support to Power BI Gateway for mashups of On-Premises and SharePoint Online data sources.

Best Regards,
Angelia