Skip to main content

    Data Factory

    Needs Votes

    Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Vote (398) Share
    Wyn Hopkins's profile image

    Wyn Hopkins on 21 Mar 2020 11:41:12

    Connecting to files stored on OneDrive and SharePoint is a difficult and confusing experience. While it is possible, it is far too difficult.

    As more and more move to working in an online environment we need a simple way of connecting.

    Administrator on 15 Aug 2024 18:30:44

    Update 8/15/2024: Moved from Power BI ideas to Data Factory ideas.

    Comments (10)
    Wyn Hopkins's profile image Profile Picture

    Wyn Hopkins on 05 Aug 2021 00:49:32

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    This is the easiest technique I've come up with so far

    https://youtu.be/vPV67RLGoOg
     

    Wyn Hopkins's profile image Profile Picture

    Power BI User on 10 Jul 2020 17:22:31

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Can't believe the process of connecting to OneDrive and SharePoint isn't more straight forward or transparent. It has to be the quickest area of productivity gain for so many users (developers or otherwise).

    Make it happen soon!

    Wyn Hopkins's profile image Profile Picture

    Power BI Ideas Admin on 10 Jul 2020 17:20:59

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Absolutely!!

    Also need to consider SPO Throttling the connections

    Wyn Hopkins's profile image Profile Picture

    Tim Callahan on 06 Jul 2020 00:17:11

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    This is a MUST!

    Wyn Hopkins's profile image Profile Picture

    Daryl on 06 Jul 2020 00:16:54

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Please, this is a major pain point for me. Thanks!

    Wyn Hopkins's profile image Profile Picture

    Neil MacMullen on 06 Jul 2020 00:14:05

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Agreed. I wrote a long rant on the user forum about how poor this experience is. I really can't see why PowerBi shouldn't be able to recognise from the path structure that a file is actually a local sync of a onedrive file and then offer to use the online version as the source.

    Wyn Hopkins's profile image Profile Picture

    Gregory Petrossian on 06 Jul 2020 00:13:53

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Won't let me vote either...

    Wyn Hopkins's profile image Profile Picture

    David Williams on 06 Jul 2020 00:12:48

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    It won't let me see the captcha on the vote button, so I can't vote, but yes... this is totally needed to make super simple.

    Wyn Hopkins's profile image Profile Picture

    Jason Tan on 06 Jul 2020 00:10:48

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    It's indeed a huge pain point to figure out the right path to connect to OneDrive Personal/Business and SharePoint. MSFT really need to come out a seamless solution ASAP!

    Wyn Hopkins's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:10:30

    RE: Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Good idea