Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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!
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.
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.
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.
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?
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.
There is a couple of thing you could try here.
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.
This is neither desktop or service, this is "Report Builder" which is a seperate power bi application
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |