Power Automate "Export to pdf" error for a DirectQuery report

I have created a PowerBI report that has a direct query to a PowerBI dataset. This DirectQuery dataset itself combines information from an Excel file (located on a SharePoint site) and is connected to a Streaming dataset.

I tried using PowerAutomate to export the report page to pdf and I am getting an error. All the visuals of the page show the same error.

I tried the same PowerAutomate flow but on the original Streaming Dataset this time, and it works fine. I also tried to export manually to pdf directly from the Online Service, and it works fine (the report connected to the DirectQuery dataset). It seems that the conversion of of the Dataset connection mode to DirectQuery is breaking the "export to pdf" functionality.
This is exactly the same problem as reported in this issue and apparently adressed by jeroenterheerdt 

The detailed business context is that I'm trying to send the report pages via email to users, who have previously submitted a Forms. The Forms information is retrieved and combined with other information (in Excel, mentioned earlier) to produced the report visuals which need to be sent to the person who submitted the Forms, hence the need to use a DirectQuery dataset (to make it live while combining information with a streaming dataset)

Thank you for your help!