Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Report Builder 3.0 produced empty report despite Data Source having data

Posted on 2012-08-17
Medium Priority
Last Modified: 2013-08-06
I’m trying to create my first simple Table report using Report Builder 3.0 and despite being morally certain there is plenty of data in my Data Source I cannot get it to return any data in my report.  This problem is evidently so simple and rare that there is no solution to it published on the Web.  What am I doing wrong or how can I zero in on the problem?

Here’s my process this far…

Created at PowerPivot application in Excel 2010 based on the Contoso Retail DW and uploaded it to the SharePoint 2010 PowerPivot Gallery where everything works fine (e.g. slicers, etc.).

Now I want to use Report Builder 3.0 to create my first a simple Table report using this PowerPivot app’s data source/model.  (I successfully created a Map report previously by following the instructions in my PowerPivot book.)

Starting with Create Report Builder Report (in PowerPivot Gallery), I open the report using Report Builder 3.0.  I see the Data Source listed in the tree, Start the Table Wizard, Create a Data Set from the Data Source Connection, Test the connection and verify it exists, and proceed to the Design a Query screen where the mystery begins.

I drag FactSales[SalesAmount] into the lower right pane where it appears (without any data underneath it).

The message in the pane says “No rows found. Click to execute the query”.  I can click repeatedly but no row of data is returned and displayed.

Next takes me to the Arrange Fields screen where I drag the Sales Amount to the Values pane.

Next previews the Sales Amount column header with [SalesAmount] under it but no data.

Next then Finish.

Run displays “Loading…” then a blank report with only the column header on it.

I will be forever grateful if you can explain this silly mystery to me.  Thanks!
Question by:daldenwilliams

Accepted Solution

daldenwilliams earned 0 total points
ID: 38314296
Thank you for looking into this, but I did just figure it out:

When using a PowerPivot data model as the basis for the Data Set it turns out that the columns I want to drag into the "data pane" are listed in two different places in the tree:  once as it's own top-level node right there in the initial list, and a second time buried under the Measures node.  Once I dragged the columns from under the Measures node everything worked as expected.
LVL 24

Expert Comment

ID: 39385196
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question