Power Bi Report Builder

[Annemie19]

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: https://northeurope.pbidedicated.windows.net/webapi/capacities/2C880813-DB24-4BFB-B48F-4F033B0557B8/...

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

Kind Regards, 

Annemie

[v-jingzhang]

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.