Publishing reports, editing them in Power BI Service and using dashboards/tiles
Part three of a six-part series of blogs

This blog shows how to publish reports that you've created in Power BI Desktop to Power BI Service. The blog also shows how you can create and edit reports online, how to create dashboards and add tiles, and how to get insights into your data.

  1. Using Power BI Service (publishing, dashboards, etc.)
  2. Publishing to Power BI Service
  3. Creating and editing reports in Power BI Service (this blog)
  4. Creating dashboards and basic tiles
  5. Adding tiles from other sources to a dashboard
  6. Analysing data within Power BI Service

This blog is part of a much longer series, which together comprise a full online training course in Power BI Service.  You can see get details of our classsrom Power BI training courses here.

Posted by Andy Brown on 29 June 2017

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Creating and editing reports in Power BI Service

I think it's much easier to create your reports in Power BI Desktop and then publish them, but you can if you prefer do everything in Power BI Service.

Creating reports in Power BI Service

To create a new report, first select a dataset:

Selecting a dataset

When you publish a report, you get a dataset with it. You can click on this dataset and use it as the basis for a new report.

 

You can now tick the columns in the tables that you want to include:

Choosing columns

It may look like Power BI Desktop, but this is actually Power BI Service.

 

This gives you a visualisation, which you can change or format in the usual way:

Visualisation

You could change this to any of the standard Power BI visualisations.

 

If you try to leave a report without saving it, you'll see this message:

Saving report

All very intuitive, really.

Pretty much anything you can do in Power BI Desktop when creating a report, you can also do in Power BI Service.

Editing reports in Power BI Service

To edit a report, first click on it to select it:

Editing a report

Click on the report that you want to edit, to select it.

 

Now choose to edit this report:

Edit report - tool

Click on the menu option shown to edit this report.

When you've finished, you can save your report with a new name, or overwrite the existing one:

Saving a report

You can choose (as here) to overwrite your existing report, or else save it under a new name.

 

One obvious pitfall when editing a published report: when someone makes a change in Power BI Desktop and republishes the report, you'll lose changes you've made in Power BI Service.

This blog has 0 threads Add post