PowerBI Enterprise gateway You don't have any gateway installed or configured for the data sources..

[Joe_100]

Hi all,

Currently we are using the Powerbi Enterprise gateway to connect to an on-premise database through an ODBC connection and use the scheduled refresh to update the report.

Normally this works ok. 

We are now creating a report using this on premise odbc connection but also getting information from a Sharepoint online list.

When using the two datasources seperatly but still in the same report i can still schedule an automatic refresh.

When i combine the data from the two sources, for example using a join. I notice the following error in PowerBi under scheduled refresh.

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

Is this normal behaviour? Any way to solve this? Not supported by PowerBI?

Many thanks!

[v-yuezhe-msft]

@Joe_100,

When you combine on-premises data source and online data source in a single dataset, you can use on-premises gateway(personal mode) to refresh your dataset.

Or you can use on-premises gateway, add all the on-premises data sources within the gateway , select "Allow user’s cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster" option as described in this blog. Please note that there is an issue about the "Allow..." option, which has been reported internally as discussed in this thread. However, based on my test, we can still use on-premises gateway to set schedule refresh for dataset even the "Allow..." option is unchecked.

Regards,
Lydia

[Joe_100]

@v-yuezhe-msft

Thanks for your reply. But i am not sure if i fully understand.

Does it only work when the gateway is installed in personal mode?

[v-yuezhe-msft]

@Joe_100,

Both personal mode gateway and on-premises gateway will work. When using on-premises gateway, you need to select "Allow..." option which is described in the above blog.

Regards,
Lydia

[Joe_100]

@v-yuezhe-msft

Unfortunetaly it is not working...

The gateway is functioning, and the checkbox is marked (indeed dissapears after you refresh the page)

The thing is, when i use the ODBC and Odata connection seperatly i am able to schedule the refresh. When i combine data from the two sources (joining two tables from the two sources for example) the error starts appearing.

[v-yuezhe-msft]

@Joe_100,

Please check my first reply, the issue you describe is known, and it is reported internally. Based on my test, when you select the "Allow..." option, don't refresh the page, go to Settings and find your dataset, then you are able to choose on-premises gateway.

If the above method doesn't work in your scenario, please install personal mode gateway as a workaround.

Regards,
Lydia

[Joe_100]

@v-yuezhe-msft

Unfortunetaly i can't get it to work.

In my report, if i remove the join between two tables (one table from Sharepoint online, one table from an ODBC connection/on prem DB)  the option to use an onpremise gateway returns.

Very strange behaviour, i suspect a bug?

[v-yuezhe-msft · Accepted solution]

@Joe_100,

This is a known issue, please review this idea.

In your scenario, please use personal mode gateway.

Regards,
Lydia

[Joe_100]

Just to be clear.

We connect to the Sharepoint library through an OData connection, we also connect to an Excel file on Sharepoint through the "Web" connection.