Data import from SharePoint RRS feed

  • Question

  • Hello


    I’m trying to import data from SharePoint to Excel to build a power pivot model. I have read/write access to the files on the SharePoint, but when I Get data in Excel from either SharePoint folder or web,  I get a no permissions message.

    I have the same problem in Power BI, but can get around it by signing in using my Organizational Account

    Does anyone know how to get around this issue in Excel?

    Thanks in advance


    Friday, October 25, 2019 3:01 PM

All replies

  • See chapter "Importing Data from Files on OneDrive or SharePoint"
    in the book
    "Collect, Combine, and Transform Data Using Power Query in Excel and Power BI"
    by Gil Raviv

    Friday, October 25, 2019 3:33 PM