Forum Discussion

俊彦 王's avatar
俊彦 王
Copper Contributor
Aug 10, 2017

Help:where is the sharepoint list in power query?

pls help me.

i can't find any sharepoint list in “Get & Transform” / “Import Data from Online Services” / Import Data from Other Sources"

 

it's only a "facebook" option in Online Services

 

i try "import data from other sources/web",excel let me login,and when click "connect",and then always prompt "can't use my credential to verify”,and status is logged in.

i am in plan O365

Tks a lot if any help!

BI & Data Analysis
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 10, 2017

    Hi,

     

    Which connectors you have depends on your O365 plan. For so called "Pro" versions (E3, etc.) you have all of them, for others (Home, etc.) you have only minimum of connectors. You may google for more details, that's not in my memory.

    • 俊彦 王's avatar
      俊彦 王
      Copper Contributor
      Aug 11, 2017
      Our Plan is Office 365 Business Premium... Thank you for answer!
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Aug 11, 2017

        If nothing changes in latest few months Business Premium has limited BI functionality. In particular, there is no Power Pivot in Excel. I guess same story with G&T connectors.

Resources