Subscription for Power BI Paginated Report occasionally displays blank rows.

[bhartisharma_in]

We are encountering an intermittent issue with one of our new reports in Fabric.

It appears that some mornings the report is showing no rows when it is mailed out, but when I go and check the live report, it is fine.

I subsequently resend the report by forcing the schedule and the email shows the correct information.

Semantic model is in direct lake mode.

[Anonymous]

Hi @bhartisharma_in ,

Do blank rows overwrite the original data? If not, I recommend that you can try to filter rows in the report that are not blank to resolve this occasional problem.

Best regards,

Mengmeng Li

[GilbertQ]

Hi @bhartisharma_in 

This should work as expected, could it be that data is coming into the Lakehouse the same time as the subscriptions are being sent?

[bhartisharma_in]

No, there are around 2 hours of gaps between both things.

[bhartisharma_in]

No, my data pipeline runs around 4AM and it's taking around 3 min or so and the subscription is scheduled for 6 AM.