Paginated Report not populating data in Service

[dkleeman]

I have created a report connecting my data to MS SQL Server in Report Builder.  Everything works fine, however, as soon as I load it into my workspace in PowerBI Service, none of the data will populate.  I have looked for this issue and can't seem to find a similar one anywhere.  Please help me understand why the report will work in Report Builder, but not in the Service.

[dax · Accepted solution]

Hi dkleeman,

As I know , when you design a paginated report, you're really creating a report definition. It doesn't contain the data. It specifies where to get the data, which data to get, and how to display the data. When you run the report, the report processor takes the report definition you've specified, retrieves the data, and combines it with the report layout to generate the report. You upload the report definition to the Power BI service, http://app.powerbi.com, either to your My Workspace or to a workspace shared with your colleagues. If the report data source is on premises, after you upload the report, you redirect the data source connection to go through a gateway. Please check whether you rediect datasource though gateway. You could refer to What are paginated reports in Power BI Premium? for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.