Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Power BI Live stream Data not getting exported to PDF when using Power Automate Flow

Hi,

 

I am trying to use Power Automate flows to export a Power BI report that uses data from a Live Stream dataset and I am getting the following error:

 

Original report:

 

LeandroMonteiro_1-1673374418590.png

 

PDF export :

 

LeandroMonteiro_0-1673374134192.png

 

I noticed that the "Can't display" issue only happens when I mix the data model, in my case I am using the Live Stream Dataset and another PBI dataset:

 

LeandroMonteiro_3-1673374753531.png

 

The report, the datasets and the Power Automate flow were created with the same user, I am sure that I have access to connect to all the datasets.

 

In my opinion this is a Microsoft issue (Maybe authentication issues) as this flow was working in the past and we haven't done any changes since then.

 

*UPDATE-

 

I decided to make another test using only live connection to the PBI Live Stream Dataset in the PBI File to prove my point:

 

Original Report-

LeandroMonteiro_2-1673375977318.png

 

PDF Export-

LeandroMonteiro_3-1673376054198.png

 

Status: Investigating
Comments
Anonymous
Not applicable

Hi @LeandroMonteiro ,

 

This document has listed the unsupported live connection types with composite models:

  • SAP HANA
  • SAP Business Warehouse
  • SQL Server Analysis Services
  • Power BI datasets
  • Azure Analysis Services

 

Per my understanding, it is not supported to combine streaming datasets with other data sources in composite model.

 

Best regards.
Community Support Team_ Caitlyn