Showing results for 
Search instead for 
Did you mean: 
irnm8dn Member

Importing Excel Online Document through Sharepoint, into PowerBI

My team currently uses an Excel Online spreadsheet which is maintained by the team.


While not an ideal datasource, I am looking to have Power BI consume this file, and represent the information in a dashboard.  I am enocountering difficulty finding a thread in the community which simply states the steps of connecting to the data using the "Get Data" function.


Can somone represent the steps in a reply, as it seems like this would be straightforward.  In some cases, depending on the "Get Data" steps that I execute - I seem to get data about the contents withing the SharePoint folder, but obviously I am looking for the data in the Excel document, not metadata about the file contents.


Thanks for the help!

Super User
Super User

Re: Importing Excel Online Document through Sharepoint, into PowerBI

Are you using SharePoint on-premises or SharePoint Online?

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)