Forum Discussion
Data Gateway missing dataset
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
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
4 Replies
- AnonymousNot applicable
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.
- C_WilsonFrequent Visitor
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-msftMicrosoft Employee
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
- zelrobericFrequent Visitor
Thanks Seth that was actually my problem don't know why it worked, but it did.