Now that you've created a group in Power BI, you can store your Excel, CSV, and Power BI Desktop files on your Power BI group’s OneDrive for Business. You can continue updating files you store in OneDrive for Business, and those updates are automatically reflected in the Power BI reports and dashboards based on the files. 

Note: Groups are only available with Power BI Pro.

Adding files to your group’s Power BI workspace is a two-step process: 

  • First you upload files to your group’s OneDrive for Business.

  • Then you connect to those files from Power BI.

Upload files to your group’s OneDrive for Business

  1. In Power BI, switch to the group’s workspace, so the group name is in the top-left corner. 

  2. Select the ellipsis () next to the group name > Files to open the group’s OneDrive for Business on Office 365.

    Note: If you don't see Files on the group menu, select Members to open the group's OneDrive for Business. There, select Files. Office 365 sets up a OneDrive storage location for your group files. This process may take some time.

  3. Here, you can upload your files to your Office 365 group's OneDrive. Select Upload, and navigate to your files.

Import Excel files as datasets or as Excel Online workbooks

Now that your files are in your group’s OneDrive for Business, you have a choice. You can: 

Import or connect to your group's files

  1. In Power BI, switch to the group’s workspace, so the group name is in the top-left corner. 

  2. Select Get Data at the bottom of the left navigation pane. 

  3. In the Files box, select Get.

  4. Select OneDrive - Your Group Name.

  5. Select the file you want > Connect.

    This is the point where you decide whether to import the data from the Excel workbook, or connect to the whole Excel workbooks.

  6. Select Import or Connect.

  7. After you import or connect, these new items are marked with a yellow asterisk.  

    Excel files have an Excel icon and are under Reports.

See also