Sharepoint Online w/t Excel and Data Gateway

[albertovaghi]

Hi all,

I have this scenario I'm dealing with: Power BI Report made in Power BI desktop with data coming from:

• Oracle source (connection through Oracle Client)
• Excel file published on Sharepoint Online

When I publish the report to PBI Service and I try to enable Scheduled Refresh, I get this error:

"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."

This is actually not true as my Oracle connection is correctly configured in the Data Gateway. Could it be that it's an issue related with Data Gateway and OAuth? I have this requirement from the business to have some info in an Excel file but I'm struggling to get it automatically updated by the data gateway.

Thanks for any help!

Regards,

Alberto

[albertovaghi]

Thank you very much for your answers!

[v-yuezhe-msft · Accepted solution]

@albertovaghi,

In your scenario, you would need to use personal gateway to refresh your dataset. For more details, please review the following knowledge base.

http://community.powerbi.com/t5/Community-Knowledge-Base/On-premise-data-gateway-is-not-available-fo...

Regards,
Lydia

[Greg_Deckler]

I have seen reports in the past where having a cloud source and an on-premises source causes some issues. You might try moving your Excel file on-premises and setting it up in the gateway.