Getting data from Excel Online?

[rbbi]

hi,

Until now, when I've used Excel as a data source it's been from local files. Now, for the first time I'm trying to access Excel online - i.e. a spreadsheet in my Office 365 One Drive. This would seem to be the most natural thing to me, but my attempts and research so far suggest this is difficult if not impossible. The one link I've found has what looks like an out of date version of Excel, copying the document link to the clipboard. https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links. I (and others) don't see this same option for copying a link.

btw, I'm using Office 365 Home and therefore (I think) One Drive Personal. My client has Office 365 Business and therefore One Drive Business but I don't have access to that yet. I'm not sure what difference that would make.

Am I missing something obvious here? Is the intention to block this most obvious (to me) way of sourcing data from Office 365? And thus force us towards using service like Azure SQL that wouldn't otherwise be needed?

thanks, Rod

[Anonymous]

While I have not attempted with the Home version of OneDrive, it is certainly possible to connect to OneDrive business files.  It being excel is fine.

[rbbi]

Thanks Ross73312,

I've now been able to try Office 365 Business and yes it works just like a local spreadsheet using the instructions on the link in my post.

So I'm wondering if anyone else can confirm this is the limitation .. and that I really need Office 365 Business and it won't work with the Home version? Seems a shame to me.

[Anonymous · Accepted solution]

Try the solution from this thread:

http://community.powerbi.com/t5/Integrations-with-Files-and/PowerBI-support-for-OneDrive-Personal-as...

[rbbi]

Fantastic, yes that works well - thanks for doing the search for this!