Sample files downloader

Now that you have data, you're on your way. Try out some of our tutorials using the built-in samples or just open the Power BI service and explore. Each of the built-in samples is also available as Power BI. Download the files individually using the links below. Selecting these links saves the file automatically to your Downloads folder. Each of the built-in samples is also available as an Excel workbook.

The Excel workbooks are designed to be used with the Power BI service. Download the files individually using the links below, or download a zip file of all the sample files. If you're an advanced user, you might want to download the Excel workbooks to explore or edit the data models. Local - If you save your file to a local drive on your computer or another location in your organization, from Power BI, you can import your file into Power BI.

Your file remains on your local drive, so the whole file isn't imported into Power BI. What happens is a new dataset is created in your Power BI site and data, and in some cases the data model, are loaded into the dataset. If your file has any reports, those reports appear in your Power BI site under Reports. If any changes are found, your dataset, reports, and dashboards are automatically updated in Power BI. The biggest difference is how you connect to the file from Power BI.

You can specify a URL or connect to the root folder. Navigate to your My Workspace or to another workspace, or create a workspace just for the sample. Select the file. Depending on where you saved the file, select Connect or Open. Choose whether to import the data or to bring the workbook into Power BI and see it exactly as it is in Excel online. If you select Import , Power BI imports the sample workbook and adds it as a new dashboard, report, and dataset, in this case each named Procurement Analysis Sample.

Optional Want to understand how the data in an Excel workbook gets converted to Power BI datasets and reports? Opening the Excel samples in Excel and exploring the worksheets provides some of the answers. When you first open a sample workbook in Excel, you may see two warnings. The first warning says the workbook is in Protected View.

Select Enable Editing. The second warning may say that the workbook has external data connections. Select Enable Content. Each workbook contains several Power View sheets. If you want to see the Power View sheets in Excel, You need to enable the Power View add-in by downloading a package of registry keys. So where's the actual data? It's in the Power Pivot data model. You don't need the Power View sheets to see the data. On the PowerPivot tab, select Manage.

Don't see the Power Pivot tab? Enable the Power Pivot add-in. Basic concepts for designers in the Power BI service. Tutorial: Connect to the Power BI samples.

These are the Windows sample files, if you have an Apple Mac see next section. These are the Apple Mac sample files, if you have are using Windows see above section. This sometimes shows a warning whenever any executable file is downloaded from the Internet and run:.

This file identifies the creator of the file as The Smart Method Limited ourselves. It is safe to click the Run anyway button at this stage as the file is protected with a digital certificate Microsoft obtain the publisher name from this certificate.

We also publish the same set of files a zip file that you can download here. Zip files are not as convenient as. EXE files but do not prompt any SmartScreen warnings. The executable file is the simplest and most effective way to install the sample files. As a digitally signed executable file it is safe to use. If this is the case you can download an alternative.

All browsers download files in different ways. You need to click on the icon and then select Open from the pop-up menu. You then need to click Unzip in the next dialog. You need to click on the Run button in this dialog.

This happens when the file associations on your computer have become corrupted. You can fix this but it is easier to simply open the file from inside Excel rather than by double-clicking it. Select your mac book from the Apple Mac Titles images above. The iPad cannot run the full version of Excel — though it can run a cut-down app version. The iPad also does not support the concept of on-device files.

The iPad needs you to install files upon a cloud drive to access them via the Internet. Our Access VBA title also has its own dedicated site. The Wealth of Nations. Hi Brendan, it sounds like everything worked correctly.

If you continue with the course you should find instructions on how to open a file, but if you have any further problems please let us know either here or via the Contact Page. What is to be done?

Thank you for your kind explanation. I am not very good with Window and tried to open Session 1 at the Unzip window. Now I can find the three files within Session 1. Thanks again. You will need a copy of Excel installed on your computer in order to use the sample files. In addition, please make sure that you have downloaded the files for your version of Excel — if you are using a Mac version of Excel make sure to download the Mac sample files.

You can also download the sample files in the alternative ZIP format on this page. Hi I have downloaded the sample files but cannot open them. If you are not using a Windows computer you will not be able to open this file. If you are using a Mac, please download the sample files for the Mac courses.

Otherwise, you can download ZIP versions of the sample files on this page. I have downloaded all the files 3 x now. All I see is the Wealth of nations. Very frustrated.

The Wealth of Nations is in Session 1, so it is in the Session 1 folder in your sample files folder. First Quarter Sales and Profit is in Session 2, so you will find it in the Session 2 folder, along with all of the other sample files for session 2.

There are also folders for all of the other sessions in the course. It sounds like you have downloaded the correct files, all you should need to do is examine the folder they are in and you should see all of the sessions. Smart, I am making my own checkbook register in excel, but would like to make it better. Is there a program you may have that can teach how to do it professionally?

The Tables feature can improve almost any workbook by allowing tables of data to be automatically formatted and allowing formulas to automatically include new data when it is added. You can learn all about tables in Session 1 of our Expert Skills course. Pivot tables are very useful for creating summaries of data. These are covered in depth in Session 8 of Expert Skills.

I have recently purchased your book from amazon Excel expert skills. Any idea where it would be please? You can always download a fresh copy of the sample files to make sure that you have the correct fileset. Download files as html, csc, css, zip, bzip2 and more. Toggle navigation Menu File Examples. Sample videos Sample audio files Sample documents Sample images Other files. Most popular file formats If we miss any, let us know! We care for our content.

All files are safe from viruses and adults-only content. Video files A great collection of video files for testing and demo use.