Creating a Report in Power BI Report Server

Leave a comment

In this post, we will go through creating a report in Power BI Report Server.

First, open Power BI Desktop for Report Server. Close the welcome window:

Select to Get Data. We will select SQL Server:

We will pull data from a localhost database:

Click Connect:

Click Load to load to the data into Power BI:

You will see:

We now need to add relationships to our data. Click on Manage Relationships:

Add relationships or press Autodetect:

Add a new chart. e.g. Extended Price vs State:

Click on Save->Power BI Report Server:

Provide a file name and click OK:

You will see the message:

Clicking on the link will take you to the report in Power BI Report Server:

Which will also appear on the home page:



Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube


Leave a Reply

Your email address will not be published. Required fields are marked *