How to Connect OneDrive to Power BI

Tired of manually uploading Excel or CSV files into Power BI every time you need to refresh a report? By connecting your report directly to a file stored in OneDrive, you can automate that entire process. This article will show you exactly how to connect OneDrive to Power BI to create reports that refresh automatically, saving you tons of time and effort.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Connect OneDrive to Power BI?

Connecting a data source from OneDrive to Power BI does more than just import data, it creates a dynamic link between your file and your dashboard. This means you don't have to re-upload your file every Monday morning. You update the Excel file, and your Power BI report updates automatically. It’s a simple setup that has some major benefits.

• Automated Data Refresh: The biggest advantage is automating your reporting. Once connected, you can schedule your Power BI report to refresh daily or even multiple times a day. As long as you update the source file in OneDrive, your Power BI dashboard will always show the latest data without any manual work.
• Seamless Collaboration: When your data source is a file in a shared OneDrive folder, your entire team can contribute. One team member can update sales numbers while another updates marketing spend in the same Excel file. Power BI will pull in all those changes during the next scheduled refresh, making it a great solution for collaborative reporting.
• Version Control in the Cloud: Storing your source files in OneDrive means they're backed up, secure, and accessible from anywhere. OneDrive also has a built-in version history, so you can easily revert to a previous version if a mistake is made - a lifesaver when dealing with critical data.

OneDrive Personal vs. OneDrive for Business

It’s important to note the difference between a personal OneDrive account and OneDrive for Business. While the process is similar, OneDrive for Business is designed for organizational use and integrates more smoothly with Power BI's authentication and sharing features. For business reporting, you should always use your OneDrive for Business account provided through your Microsoft 365 subscription.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

What You’ll Need Before You Start

To follow along, make sure you have a few things ready. The setup is straightforward, but having these items in place will make it even smoother.

• A Power BI Account: You can start in Power BI Desktop for free, but you'll need a Power BI Pro or Premium license to publish your report and set up an automatic scheduled refresh.
• A Microsoft 365 Account: You need an account that includes OneDrive for Business.
• Your Data File: Have an Excel workbook (.xlsx) or a CSV file (.csv) saved in a folder within your OneDrive for Business.
• Power BI Desktop: While some connections can be made in the Power BI web service, the most powerful and flexible method starts with Power BI Desktop. We recommend downloading and installing it if you haven't already.

Step-by-Step: Connecting an Excel File in OneDrive to Power BI Desktop

This is the most common and robust method for creating refreshable reports. We’ll build the connection in Power BI Desktop, then publish it to the Power BI Service to set up the automated refresh schedule.

Step 1: Get the Correct File Path from OneDrive

This is the most important step and where most people run into trouble. A standard browser sharing link from OneDrive will not work. You need to get the direct file path. The easiest way to do this is by opening the file in the desktop version of Excel.

1. Navigate to your Excel file in your OneDrive folder using your web browser.
2. Click the file to open it in Excel for the web.
3. At the top, click Editing and select Open in Desktop App.
4. Once the file opens in your desktop Excel application, go to File > Info.
5. Just below the file name, click Copy path. This will copy the direct URL to your clipboard.

Your copied path will look something like this:

https://yourcompany-my.sharepoint.com/personal/your_name/Documents/Reports/SalesData.xlsx?web=1

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Clean the URL

Power BI requires a slightly cleaner version of this path. Paste the copied link into a text editor (like Notepad) and delete the ?web=1 portion from the end. The final URL should look like this:

https://yourcompany-my.sharepoint.com/personal/your_name/Documents/Reports/SalesData.xlsx

This clean URL is what we'll use in Power BI.

Step 3: Connect to the File in Power BI Desktop

Now, let's head over to Power BI Desktop to establish the connection.

1. Open Power BI Desktop.
2. On the Home tab, click Get Data and select Web.
3. A dialog box will appear. Paste your cleaned URL into the field and click OK.
4. Power BI will then ask you to sign in to authenticate. Select Organizational account from the left-hand menu.
5. Click Sign in and enter the same Microsoft 365 credentials you use for your OneDrive for Business.
6. After signing in, click Connect.

Step 4: Load Your Data

Once connected, Power BI will show you the Navigator window. Here, you'll see all the available tables and sheets within your Excel workbook.

• Check the box next to the table or sheet you want to import. A preview will appear on the right.
• If your data is clean and ready, you can click Load to import it directly into your data model.
• If you need to clean or transform your data first (e.g., remove columns, change data types), click Transform Data. This will open the Power Query Editor, where you can prepare your data before loading it.

That's it! Your OneDrive file is now connected as a data source in your Power BI report. You can start building visuals, measures, and calculated columns just like you would with any other data source.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Setting Up Scheduled Refresh in the Power BI Service

Once you’ve built your report in Power BI Desktop, the final step is to publish it and set up the automatic refresh. This is where the magic happens.

1. In Power BI Desktop, go to the Home tab and click Publish.
2. Select a workspace to publish your report to (e.g., "My workspace" or a shared team workspace).
3. After it publishes successfully, click the link to open the report in the Power BI Service (app.powerbi.com).
4. In the workspace where you published your report, find the new dataset (it will have the same name as your file). Datasets are marked with an orange icon.
5. Hover over the dataset, click the ellipsis (...), and select Settings.
6. Find the Data source credentials section and expand it. Power BI may have already stored your credentials, but if you see an error, click Edit credentials.
7. In the pop-up, make sure the authentication method is set to OAuth2 and the privacy level is set to Organizational. Sign in again with your Microsoft 365 account to grant Power BI permission to access the file.
8. Next, expand the Scheduled refresh section.
9. Toggle the switch to turn it on.
10. Choose your desired refresh frequency (e.g., Daily), select your time zone, and add the times you want the refresh to run. You can add multiple refresh times per day depending on your Power BI license.
11. Click Apply.

Your report is now configured to automatically update based on the schedule you set. Any changes saved to the Excel file in OneDrive will be pulled into your Power BI report automatically, ensuring your data is always current.

Final Thoughts

Connecting OneDrive to Power BI transforms your manual reporting process into an automated, efficient system. By setting up this live link and a refresh schedule, you ensure your stakeholders always have the most current data without you needing to press a single button. It's a foundational skill for anyone looking to build reliable, hands-off business intelligence dashboards.

Of course, your data often lives in more places than just OneDrive. We built Graphed to simplify this entire process by bringing all your data sources - from sheets in OneDrive to platforms like Google Analytics, Shopify, and Salesforce - together in one place. You can use simple, natural language to instantly build the same kinds of real-time dashboards that used to take hours of manual setup, freeing you up to focus on strategy instead of report-building.