OneDrive is Microsoft's cloud storage platform for storing and sharing files. When business data such as Excel workbooks or CSV files is stored in OneDrive for work or school, Power BI can use those files as a source for reporting and analysis.
Connecting Power BI to OneDrive makes it easier to work with cloud-based business files without repeatedly downloading and uploading them. When supported files are updated and saved in OneDrive, Power BI can synchronize changes with the corresponding Power BI content.
What You Need Before Connecting
Before starting, make sure you have:
- Power BI Desktop installed
- Access to OneDrive for work or school
- Permission to access the required file
- A Microsoft account associated with your organization's OneDrive
- A supported file such as Excel or CSV
- A properly structured dataset for reporting
For the smoothest synchronization experience, Microsoft recommends using the same account for OneDrive and Power BI when working with cloud-hosted Excel files.
Step 1: Prepare Your File in OneDrive
Before connecting Power BI, upload the file you want to analyze to OneDrive for work or school.
For example, you might have an Excel workbook containing:
- Sales information
- Customer records
- Product information
- Employee details
- Inventory data
- Project information
Make sure the file has a clear structure and that the data is organized into tables where appropriate.
Tip: Avoid unnecessary blank rows, merged cells, and inconsistent column names in your source file.
Step 2: Open Power BI Desktop
Open Power BI Desktop.
From the Home tab, select:
Home → Get Data
Depending on the file type, you can select the appropriate connector, such as:
Excel workbook
or
Text/CSV
Power BI can work with files stored in OneDrive for work or school using supported cloud-file connection methods.
Step 3: Select the Appropriate File Connector
If your OneDrive file is an Excel workbook, select:
Excel workbook
If your file is a CSV file, select:
Text/CSV
Then select:
Connect
Step 4: Access the OneDrive File
Depending on the Power BI experience and connection method, you can access the OneDrive file using its cloud location or file path.
For OneDrive for work or school, Microsoft documents several ways to access cloud-hosted files, including using a file URL through the Web connector.
If using the Web connector:
- Open the required file from OneDrive.
- Open the file in Excel.
- Select File → Info.
- Select Copy Path.
- In Power BI Desktop, select Get Data → Web.
- Paste the file path.
- Remove the ?web=1 portion from the URL if it is present.
- Select OK.
Step 5: Authenticate Your OneDrive Connection
Power BI may prompt you for credentials when connecting to the file.
For a OneDrive for work or school file, select:
Organizational Account
and sign in with your Microsoft 365 organizational account.
Microsoft recommends using OAuth2 when configuring service refresh for a OneDrive for work or school file.
Step 6: Select the Data From the File
After connecting successfully, Power BI displays the available data in the file.
For an Excel workbook, you may see:
- Worksheets
- Tables
- Named ranges
- Other supported workbook data
Select the required table or worksheet.
Then choose:
Load
or
Transform Data
For most reporting projects, selecting Transform Data first allows you to review and clean the information before loading it into Power BI.
Step 7: Transform the OneDrive Data Using Power Query
Selecting Transform Data opens the Power Query Editor.
You can use Power Query to prepare the OneDrive data before building the report.
Common transformations include:
- Removing unnecessary columns
- Renaming columns
- Changing data types
- Filtering rows
- Removing duplicate records
- Replacing blank values
- Splitting columns
- Combining data
- Creating custom columns
For example, a sales workbook might contain:
- Order Date
- Customer Name
- Product
- Quantity
- Unit Price
- Sales Amount
- Region
- Salesperson
You can clean and standardize these fields before loading the data into the Power BI model.
Related Offerings
Step 8: Set the Correct Data Types
Review the data types of important columns.
For example:
Column
Data Type
Order Date
Date
Customer Name
Text
Quantity
Whole Number
Unit Price
Decimal Number
Sales Amount
Decimal Number
Completed
True/False
Correct data types are important for calculations, filtering, sorting, and visualizations.
Step 9: Apply the Transformations
After preparing the data, select:
Home → Close & Apply
Power BI applies the transformation steps and loads the data into the report.
Step 10: Create Your Power BI Report
Once the OneDrive data has been loaded, create interactive Power BI visuals.
For example, if your OneDrive Excel file contains sales data, you could create:
Sales Overview
Display:
- Total Sales
- Total Orders
- Total Customers
- Average Order Value
Sales by Region
Compare sales performance across different regions.
Sales by Product
Identify the products generating the highest revenue.
Monthly Sales Trends
Analyze sales performance over time.
Salesperson Performance
Compare sales results across sales representatives.
Step 11: Publish the Report to Power BI Service
After completing the report, select:
Home → Publish
Choose the appropriate Power BI workspace.
After publishing, the report and semantic model become available in Power BI Service according to the permissions configured for the workspace.
Step 12: Keep the OneDrive File and Power BI Content Synchronized
When an Excel workbook or CSV file is stored in OneDrive or SharePoint Online and imported into Power BI, Power BI can synchronize changes from the source file.
For Excel workbooks, Microsoft states that Power BI checks the cloud file approximately every hour for changes. When the file changes and is saved, the corresponding Power BI content can be updated.
This means that when you update and save the source Excel file in OneDrive, the changes can flow into the Power BI environment without manually uploading the file again.
Important: OneDrive synchronization and semantic model data refresh are related but different processes. OneDrive refresh synchronizes the Power BI content with the cloud-hosted source file; a semantic model refresh retrieves updated data from the underlying data sources.
Step 13: Configure Refresh Settings
After publishing, open the semantic model settings in Power BI Service.
Review the available refresh options.
Depending on how the file and data source were imported, you may be able to use:
- Refresh now
- Schedule refresh
- OneDrive refresh
Microsoft documents that OneDrive-connected semantic models can be synchronized automatically, with Power BI checking for changes approximately every hour by default.
Working With CSV Files in OneDrive
Power BI can also use CSV files stored in OneDrive.
For example, a CSV file might contain:
- Customer data
- Sales transactions
- Product information
- Marketing data
- Operational records
When a CSV file stored on OneDrive is connected to Power BI, the data is imported into the Power BI semantic model.
Microsoft states that changes saved to a connected CSV file in OneDrive or SharePoint can appear in Power BI, usually within about an hour.
Important: Microsoft has announced changes to the legacy CSV import experience. Semantic models created through the legacy CSV import experience stop refreshing after July 31, 2026, and stop loading after August 31, 2026. For new work, use the current supported import experience rather than relying on the legacy workflow.
Working With a Power BI Desktop File in OneDrive
OneDrive can also be used to store the Power BI Desktop .pbix file itself.
This is different from using an Excel or CSV file as the data source.
When a .pbix file is stored in OneDrive or SharePoint Online and imported into Power BI Service, Power BI can synchronize changes made to the report file.
For example, changes to:
- Measures
- Column names
- Visualizations
- Report pages
- Model information
can be synchronized with the Power BI Service. Microsoft states that these changes typically synchronize within about an hour.
Common Issues When Connecting Power BI to OneDrive
1. OneDrive File Cannot Be Found
Check that:
- The file still exists.
- You are signed in with the correct Microsoft account.
- You have permission to access the file.
- The file is stored in OneDrive for work or school if using organizational authentication.
- The correct file path or URL is being used.
2. Authentication Failed
If Power BI cannot authenticate the OneDrive file:
- Confirm that you are using the correct organizational account.
- Check your access to the file.
- Review the credentials saved in Power BI.
- For Power BI Service refresh, verify that the appropriate OAuth2 authentication is configured for OneDrive for work or school.
3. Excel Data Is Not Appearing
If the required worksheet or table does not appear in Navigator:
- Check that the workbook contains supported data.
- Confirm that the required worksheet or table exists.
- Make sure the file is not corrupted.
- Verify that you selected the correct workbook.
4. Changes in Excel Are Not Immediately Visible
Updates to files stored in OneDrive are not necessarily reflected instantly.
Microsoft states that Power BI checks OneDrive-connected files approximately every hour for changes.
If you need to verify an update, review the synchronization and refresh status in Power BI Service.
5. Power BI Service Refresh Fails
If the report works in Power BI Desktop but refresh fails in Power BI Service:
- Check the data source credentials.
- Verify OneDrive permissions.
- Confirm the file still exists.
- Review the semantic model refresh settings.
- Check the authentication method.
- Verify that the file path has not changed.
6. The File Was Moved or Renamed
If an Excel or CSV file is moved to another OneDrive folder or renamed, the existing connection may no longer work as expected.
Update the connection to point to the new file location.
Best Practices for Power BI and OneDrive
Use OneDrive for Work or School
For organizational reporting, use OneDrive for work or school with your Microsoft 365 organizational account.
This provides a more suitable environment for controlled access and collaboration.
Keep the Source File Structured
For Excel files:
- Use clear column names.
- Keep headers consistent.
- Avoid unnecessary merged cells.
- Use Excel tables where appropriate.
- Keep data types consistent.
A well-structured source file makes Power BI data preparation easier.
Avoid Changing Column Names Frequently
If your Power BI model depends on specific column names, changing those names in the source Excel file can cause refresh or transformation issues.
Maintain consistent column names whenever possible.
Use Power Query for Data Preparation
Clean and transform the OneDrive data in Power Query rather than manually modifying the source file every time.
This creates a repeatable data preparation process.
Keep File Locations Consistent
Avoid frequently moving or renaming source files.
A stable OneDrive location helps maintain a reliable Power BI connection.
Plan Your Refresh Strategy
Understand the difference between:
OneDrive refreshSynchronizes Power BI content with changes to the source file.
Semantic model refreshRefreshes the data in the Power BI semantic model from its underlying data sources.
Microsoft recommends considering the order of these processes when both OneDrive synchronization and scheduled data refresh are being used.
Conclusion
Connecting OneDrive to Power BI provides a convenient way to work with cloud-hosted business files such as Excel workbooks and CSV files.
By storing source files in OneDrive for work or school, users can connect the files to Power BI, prepare the data with Power Query, create interactive reports, and keep Power BI content synchronized with changes made to the source files.
Power BI also supports working with .pbix files stored in OneDrive or SharePoint Online, allowing changes made to the report file to be synchronized with Power BI Service.
With a well-structured source file, consistent data, appropriate authentication, and a planned refresh strategy, OneDrive can provide a practical cloud-based foundation for Power BI reporting.
