Report Builder 3.0 produced empty report despite Data Source having data
Posted on 2012-08-17
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!