power bi import Sharepoint online excel

[pcray]

Hi

looking for help, as im having a bit of challenge with importing an excel from sharepoint online to power bi.

ive recently upgraded from power bi to pro/premium.

i can see the file in question via the "get data" approach.

however, when i edit the query to try and manipulate the data i cant see to find the relevant fields to access the tables in questions?

when ive looked at the help tutorials they infer there should be a heading called "name" but as you can see its not listed?

any ideas?

out of interest i can do the whole process without issue if i use a local file. 

[v-yuezhe-msft]

@pcray,

Do you use Web entry in Power BI Desktop to connect to SharePoint Online Excel? Could you please describe more details about what specific field you are finding?

When I connect to SharePoint Online Excel in Power BI Desktop, it brings all the data and fields of the excel table.

Regards,
Lydia

[pcray · Accepted solution]

Hi Lydia

its ok i realised i was using the wrong connect approach. i was using the sharepoint option when the web one seems to be the one that does the job.

all working now

thanks

peter