In this blog post, we will learn how to Load a File from OneDrive Personal into Power BI Desktop and connect the OneDrive file to Power BI Desktop.
Loading a file from OneDrive Personal into Power BI Desktop is often done to take advantage of :
- Cloud Storage and Accessibility. You ensure that your data is always available, whether you’re working on your desktop, laptop, or even a different location.
- Automatic Syncing: When you make changes to a file in OneDrive, it is automatically reflected in Power BI if you refresh the dataset.
- Backup: If you accidentally delete or overwrite data, you can recover previous versions of the file.
- Real-Time Data Updates: If your Excel file or other data source in OneDrive is updated regularly, you can set up Power BI to refresh the data on a schedule. This ensures that your reports always display the most current data without requiring manual updates or re-uploads.
Load a File from OneDrive Personal into Power BI Desktop
To load a file from OneDrive Personal into Power BI Desktop, you can follow these steps:
- Go to OneDrive and navigate to the folder containing your Excel file.
- Get the Direct Link to Your File, Right-click on the file and select Copy Link.
Before using the link in Power BI, make sure the link format looks like the following:
https://yourorganization-my.sharepoint.com/personal/yourname_organization_com/Documents/yourfolder/yourfile.xlsx
Replace
- yourorganization-my.sharepoint.com: with your organization’s SharePoint URL.
- yourname_organization_com: with your personal username for OneDrive.
- Documents/yourfolder/yourfile.xlsx: with the correct file path and name.
- Open Power BI Desktop.
- Go to Get Data → Web.
- Paste the copied link and make sure the URL is pointing directly to the Excel file
Now your Excel file is loaded to your Power BI and this is the Load a File from OneDrive Personal into Power BI Desktop.
You can choose which data you want to display from the listed tables in your file.
All you have to do after connecting one drive file to the Power BI desktop is to ensure the file is shared correctly with the account you’re using to connect to Power BI, and that you have permission to access the file.
By following these steps, you can efficiently leverage OneDrive as a cloud storage solution to integrate and sync data into Power BI for up-to-date reporting and analysis
See Also
Join us
- Subscribe Power Platform Geeks.
