Forum Discussion

Annemie19's avatar
Annemie19
Helper II
5 years ago

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

 

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

 

Kind Regards, 

Annemie

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    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.