Skip to main content

Power BI

Needs Votes

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

Vote (342) 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.

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

e9b52516 82bb-4ff4-8fbb-3f185d1c7139 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

512085e3 2539-4d4b-8230-3a7dc0b13e1b 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

4ec444d2 be9f-453e-a27f-89fb2e22c293 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

ff238841 3458-45b7-879e-063ae9abbe4c 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

ab782e26 ffa8-4cfe-b9eb-b032bfadf932 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

145deb2d c1e1-45d1-a718-91953c2747b2 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

e1dced4e e4c6-4b28-9259-a1e0e025171f 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

e769b37d 10f6-4cae-909f-57e27e3bb487 on 06 Jul 2020 00:10:30

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

Good idea