Forum Discussion

cmcreynolds's avatar
cmcreynolds
Helper I
10 years ago

Excel 2016 "Get & Transform" and OneDrive

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 (vi...
Need Help
cmcreynolds's avatar
cmcreynolds
Helper I
10 years ago

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's avatar
    cmcreynolds
    Helper I
    10 years ago

    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.