Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Power Bi Report Builder

Hi there, 


I have built a report in the report builder desktop app which runs fine. 


As soon as I publish it to the Power Bi Service I get the below error. 


Unable to render paginated report
Query execution failed for dataset 'Par_DealNumber'.
Activity ID: 41bcb0f6-a8d5-284f-45d1-fe20a6b17d6f
Request ID: 41bcb0f6-a8d5-284f-45d1-fe20a6b17d6f
Status code: 400
Time: Thu Nov 12 2020 08:38:19 GMT+0200 (South Africa Standard Time)
Cluster URI:


The gateway is set up. Can someone please help with this?


Kind Regards, 



Please refer to Paginated reports in Power BI: FAQ - Power BI | Microsoft Docs first and check whether there is any unsupported data sources / authentication methods / features and limitations. And whether the paginated reports workload is enabled in the capacity admin portal page.


Currently, paginated reports don't support the following items:

  • Shared data sources
  • Shared datasets
  • Drillthrough and click-through to other reports
  • Linked reports
  • Custom fonts


Here's something to keep in mind when working with DateTime fields in paginated reports.

  • Currently there are some globalization limitations related to DateTime parameters. All DateTime parameters in the Power BI service are fetched in US format (MM/DD/YYYY) regardless of how you design the DataTime in Power BI Report Builder.


Supported data sources for Power BI paginated reports - Power BI | Microsoft Docs


Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors