Direct Query - Paginated Report Visual in Power BI

[naelske_cronos]

Hello,

I have implemented a Paginated Report visual in my Power BI report and this is a combination of Direct Query and Import.

The sum of forecast comes from a Direct Query table and is live data as soon as someone enters data. When I click on 'refresh visuals' the data in the table visual (on the right shide) is updated automatically but the Paginated Report visual on the left side is not updated? Only by refreshing my browser it is updated.

The paginated report that is created refers to the same dataset as the report itself with an 'EVALUATE ...'.

Is that normal behaviour or is there a way to also update the Paginated Report visual with 'refresh visuals' or another way? 

Thank you!

[Anonymous · Accepted solution]

Hi @naelske_cronos 

Maybe you can try the following:

Use the AutoreRresh feature of Paginated Reports, which needs to be turned on in Power BI Report Builder.

I found some relevant documents, I hope them can help you.

Power BI Paginated Reports June 2019 Feature Update Summary | Microsoft Power BI Blog | Microsoft Po...

paginated report - automated refresh using cached ... - Microsoft Fabric Community

Data retrieval guidance for paginated reports - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

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