Make it easier to obtain Excel file path from OneDrive
When referencing Excel files held on OneDrive with Power Query you need to download the Excel file, open it, copy the path and then remove ?web=1 from the end of it. It would be great if there was a right click or ... option when selecting an Excel file in OneDrive that would give you this path without the ?web=1 on the end.
Jose Ricardo commented
It would be much better.. Good Idea!!
Garrett Tedeman commented
Absolutely. Any way to open-up connections to OneDrive files also opens-up other interesting possibilities.