how to setup onedrive for business in enterprise gateway

[Johan]

Hi,

I know it's possible to link an excel file in onedrive for business directly in powerbi service.

However it's not possible to mashup with onprem data. So I have a gateway installed for the onprem files.

I hope to be able to mashup data in the query editor between the onedrive for business file and the local files.

To do that I want to refresh the onedrive for business file also through the enterprise gateway.

How to set that up?

Thanks,

Johan.

[v-shex-msft · Accepted solution]

Hi @Johan,

>>To do that I want to refresh the onedrive for business file also through the enterprise gateway.

Current on premise gateway support to onedrive for business files and local files, but append/combine features(on premise and online sources) still not support.

You can take a look at below idea to know more about these:

We’ve started working on supporting oAuth based connections to go thru the gateways in Power BI which is the main blocker to why you can’t combine today. We’re starting with personal gateway, then will support the enterprise gateway (on-premsies data gateway) shortly after. Thank you for your continuous feedback and passion for this area. Stay tuned, we’re getting close!

Combine enterprise gateway and online data sources

Regards,

Xiaoxin Sheng