Excel 2016 "Get & Transform" and OneDrive

[cmcreynolds]

Trying to sort things out here.

I'm trying to build an Excel 2016 workbook with connections to OneDrive files AND external sources (e.g. Salesforce), have the connections scheduled to refresh (via PowerBI?), and share that file on OneDrive.

My question: Is OneDrive considered "on premises"? (I'm trying to determine whether or not I need a gateway - I think I do) I have a ticket open with PowerBI, but this terminology came up in our last e-mail exchange. The reason why I'm asking is that in Excel 2016, there's no way to differentiate between a OneDrive file and one that is local, say on my machine's hard drive- or is there?

[ankitpatira]

@cmcreynolds I believe you require either personal or enterprise gateway. I am pointing you to few articles that may help you understand on your requirements.

https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-excel-file-onedrive/

https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-desktop-file-onedrive/

[cmcreynolds]

Thank you - but I've read those articles about 80 times.

I know WHAT the difference between on-premises and OneDrive is - for where my Excel file is stord AND where I get my data. But where I think the issue is, at least with the PowerBI person with my ticket, is that "Get & Transform" shows no differentiation between OneDrive and, say, a table on my desktop. (again, I am trying to query data from a website, Salesforce, and several files and folders on OneDrive)

I agree, @ankitpatira, I believe I require one of the gateways, but the person helping me says I do not.

[cmcreynolds]

One Drive may be off premises, but when a file on OneDrive is selected in "Get & Transform" - it's Power BI that automatically detects and notifies the user that a gateway is required.