Forum Discussion
Problem Connecting Power BI to personal OneDrive
HI timbckr ,
You're facing an issue because personal OneDrive links do not work the same way as SharePoint or OneDrive for Business when connecting to Power BI. The URL you are using points to a webview page, not the actual file itself.
Solution 1: Use OneDrive Sync to Access Local Path
Sync OneDrive to your PC
- Click on the OneDrive icon in your taskbar.
- Sign in with your personal Microsoft account.
- Sync the folder that contains your Power BI files.
Use the Local Path in Power BI
- Once synced, your files will be available in C:\Users\YourUsername\OneDrive\...
- Open Power BI Desktop → Get Data → Excel (or CSV, as needed) → Browse and select the file from your local OneDrive folder.
Solution 2: Use OneDrive "Web" Link for Power BI Service
If you need automatic syncing with Power BI Service:
Upload your file to OneDrive Personal.
Get the OneDrive Direct Link:
- Open OneDrive in a browser.
- Locate the file, right-click, and select Embed or Share.
- Copy the direct download link (not the view link).
Use the "Web" Connector in Power BI:
- Open Power BI Desktop.
- Go to Get Data → Web.
- Paste the direct link (ending in .xlsx or .csv).
Solution 3: Move to OneDrive for Business
If your university requires OneDrive integration, check if they provide OneDrive for Business. It integrates seamlessly with Power BI like SharePoint.
Please mark this post as solution if it helps you. Appreciate Kudos.
Hi, yes that are options, thank you!.
The Problem however is, that the data and all measures are connected to the URL of the Sharepoint. So i would like to just changed the URL of the DataSource, instead of doing all of this again.
Im only working with the Desktop Version of PowerBI. Is there a possibility to generate the URL of the personal OneDrive so that the SharePoint and OneDrive URL could just be exchanged?
Thank you!