Report Builder 3.0 produced empty report despite Data Source having data

Posted on 2012-08-17
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

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    deleted few lines of my note book in sharepoint note book 9 13
    Sum Per Month 7 23
    best way to upgrade 3 28
    query question 4 18
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now