cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrewDavies437
Helper I
Helper I

Power BI Report Builder (newbie)

Hello, i'm tasked with learning how to produce a report with the report builder. However, I'm finding it awfully confusing. 

 

I'm trying to start by adding client address to the top of the page. 

 

AndrewDavies437_0-1656510083581.png

However when I hit run, nothing shows apart from the title. Why is nothing showing and how do I get it so that I can show a client's address details? I have connected to my datasource which has a client ID and address details. I'm not sure how to show these details on the report. 

Thnks for any advice or help!

7 REPLIES 7
Seanan
Continued Contributor
Continued Contributor

Hi @AndrewDavies437 

Have you connected your dataset after connecting your datasource?

Once you have connected your dataset in the left hand pane, you can drag your columns of data on to the report.

NVIDIA_Share_9RezgoClsa.pngNVIDIA_Share_ubSZKbnle1.png

 

 

 

 

 

 

 

 

 

Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.

Thanks for the reply. Yes i have made a dataset after making my datasource. I can't see why the data wouldn't show in the boxes. It doesn't seem as easy as drag and drop as when I hit "run" nothing shows.

Seanan
Continued Contributor
Continued Contributor

Hi @AndrewDavies437 

Where is your datasource coming from? is it Excel, PBI etc? 

When you are creating a new dataset make sure you are selecting the correct data source and also it is worth click the Query Designer button. Here you can check to make sure that your dataset is actually pulling data through.

NVIDIA_Share_oTRmwCep1P.png

 

 

 

 

 

 

 

 

 

 

 

 

NVIDIA_Share_nQTthgEpyc.png

 

 

 

 

 

 

Please let me know if your dataset is pulling through data correctly.

Hi

 

My data is definitely pulling through. I've been using the query designer and my query is validated. 

 

So my data has many clients, each with a long line address 1 2 and 3. How do i tell it to pick up a specific client's data and show it on the screen?

AndrewDavies437_0-1656577677628.png

 

When i click run curently it shows nothing apart from the header "Statement".

 

I tried creating a parameter and putting that in my query for "client id" but it complains about a circular reference. 

All i want to do at this stage is pick a client ID and show their address details on the page. 

 

Thanks for any help.

Seanan
Continued Contributor
Continued Contributor

Hi @AndrewDavies437 

There is a couple of thing you could try here.

  1. Under insert click the table dropdown and select table wizard -> drag the contactname in the values area first then drag the address columns -> click next both time and see if this outputs a result.
  2. If that doesn't work you could try adding a parameter for the contactname to do this, right click on the parameters folder -> new parameter -> name the prompt anything you want -> make sure the datatype is text (for contact names) and then hit next. Next right click on your client_address_details dataset and click dataset properties. Go to the filters pane and add a new filter like this:

PowerBIReportBuilder_OrVTw3k9DC.png

 

 

 

The value is your paramaters prompt name. 

When you run the report now, you should be prompt to input a contact name.

Please let me know if this still does not resolve your issue.

croberts21
Post Patron
Post Patron

  1. Do you have PBI Desktop or PBI Service? 
  2. What is this run button? I've never heard of it in PBI. 

This is neither desktop or service, this is "Report Builder" which is a seperate power bi application

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors