Create quick reports in the Power BI service

APPLIES TO: ❌ Power BI Desktop ✔️ Power BI service

There are several ways to create reports quickly in the Power BI service. Instead of downloading the Power BI Desktop app and importing the data, you can paste data straight into Power BI on the web, and Power BI automatically generates visuals for you.

New to creating in Power BI? Try reading Reports in Power BI for some quick background information.

Use Power B I Quick Create to create a report quickly.

Ways to create reports

Continue reading this article for the basics of creating quick reports. These other articles are about reports based on specific kinds of data:

Create a quick report

In the navigation pane in the Power BI service, you can select the Create button that opens a page where you can select your data source. It's also accessible from the New report button on Home.

Create entry point icon in the Power B I service.

Currently, we only support creating a report based on an existing dataset, or pasting or manually entering data directly in a table. Over time you'll see other sources, such as uploading an Excel file.

Add data to create a report, source options.

When you choose to paste or manually enter data, you get a grid that you can start to type into. You can also paste data by using Ctrl + V or the context menu.

Type or paste in the Enter Data window.

You can use the context menu to add and remove columns. If your pasted data includes a header row, select Use first row as headers to automatically promote the first row to the header row. Power BI automatically detects the data types, but you have the option to set them manually. Select the Data type button next to the column name.

Change the data type of the column.

As you go through the creation process, Power BI creates a new dataset for you, and autogenerates a summarized view of your data. These autogenerated visuals propel you from raw data to insights faster than ever.

Select data fields to generate new visuals.

Changing the data you see in the report is easy, too. Use the Your data pane to add or remove fields from the report. Select and deselect fields to update what you want to measure and analyze. Power BI automatically plots meaningful charts based on your field selection. Read Interact with autogenerated "quick" reports to see all the ways you explore and modify these reports.

Switch to full edit experience

If you want to switch to a full edit experience, select the Edit button in the menu bar. Be aware though, that once you save the report in the full edit experience, you can't go back to the quick edit view.

Select the Edit button in the menu bar.

This experience should make it easier to create reports on your data and unlock the power of report building to a whole new set of users. Try the new Create experience today.

Considerations and limitations

To view licensing and model limitations, review the Considerations and limitations section of the Interact with autogenerated "quick" reports article.

Get data limitations

  • If you use the Paste or manually enter data option, there’s currently no way to update the data later. If you want to add, modify, or delete data later, you need to go through the Create workflow again and get a new report.
  • If you have a CSV or Excel file, you need to use the paste option to add your data. A file upload option is coming later.
  • When copying data into the Enter data window, the size of data you paste can't exceed 512 KB.
  • The table name can’t be longer than 80 characters, and column names can’t be longer than 512 characters.
  • Table and column names can’t contain double quotes ("), periods (.), or leading or trailing white spaces.

Report limitations

If you use the Edit option to switch into full editing mode and save the report, you can no longer switch back to the auto-generated view with the summarize pane. Power BI reminds you of this when you select Edit.

Switch to Edit mode from Quick Create mode.

Next steps