cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Getting data from Excel Online?

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

1 ACCEPTED SOLUTION
Community Champion
Community Champion

4 REPLIES 4
Community Champion
Community Champion

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.

(I no longer have access to this account)

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.

 

Community Champion
Community Champion

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors