Forum Discussion

pcray's avatar
pcray
Frequent Visitor
8 years ago
Solved

power bi import Sharepoint online excel

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. 

  • pcray's avatar
    pcray
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      pcray
      Frequent Visitor

      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