Connect to files stored in OneDrive for your Power BI workspace
After you've created a workspace in Power BI, you can store your Excel, CSV, and Power BI Desktop files on the OneDrive for Business for your Power BI workspace. You can continue updating the files you store in OneDrive. Those updates are automatically reflected in the Power BI reports and dashboards based on the files.
The new workspace experience changes the relationship between Power BI workspaces and Office 365 groups. You don't automatically create an Office 365 group every time you create one of the new workspaces. Read about creating the new workspaces
Adding files to your workspace is a two-step process:
- First you upload files to the OneDrive for Business for your workspace.
- Then you connect to those files from Power BI.
Workspaces are only available with Power BI Pro.
1 Upload files to the OneDrive for Business for your workspace
In the Power BI service, select the arrow next to Workspaces > select the ellipsis (…) next to your workspace name.
Select Files to open the OneDrive for Business for your workspace on Office 365.
If you don't see Files on the workspace menu, select Members to open the OneDrive for Business for your workspace. There, select Files. Office 365 sets up a OneDrive storage location for your app's group workspace files. This process may take some time.
Here, you can upload your files to the OneDrive for Business for your workspace. Select Upload, and navigate to your files.
2 Import Excel files as datasets or as Excel Online workbooks
Now that your files are in the OneDrive for Business for your workspace, you have a choice. You can:
- Import the data from the Excel workbook as a dataset. Then use the data to build reports and dashboards you can view in a web browser and on mobile devices.
- Or connect to a whole Excel workbook in Power BI and display it exactly as it appears in Excel Online.
Import or connect to the files in your workspace
In Power BI, switch to the workspace, so the workspace name is in the top-left corner.
Select Get Data at the bottom of the nav pane.
In the Files box, select Get.
Select OneDrive - Your Workspace Name.
Select the file you want > Connect.
Select Import or Connect.
If you select Import, then the workbook appears on the Datasets tab.
If you select Connect, then the workbook is on the Workbooks tab.