Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Error when export a direct query report to a PBI dataset using power automate

We have created a PBI report that has a direct query to a PBI dataset (this dataset has a connection to Azure SQL Database) and when we try to export it in PDF format using Power Automate we are gett...
Need Help
  • jeroenterheerdt's avatar
    jeroenterheerdt
    3 years ago

    Hi Anonymous I was able to reproduce this issue and we have deployed a fix which should be deployed to you in the next week or so. Basically the export to PDF was broken for the following scenarios:
    - exporting to PDF using the Service UI for a report that has a DQ connection to a source such as Azure SQL

    - exporting to PDF using the Service UI for a report that has a DQ connection to a Power BI dataset (composite on Power BI datasets)

    - exporting to PDF using Power Automate for a report in a Premium workspace that has a DQ conneciton to a Power BI dataset (composite on Power BI datasets). This is your scenario.

     

    Please check this again in a week. If the issue still persists, let me know.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi there - seeing similar behaviour for PNG exports connected to Power BI dataset. Was the fix solely for PDF exports?

 

 

Nexter's avatar
Nexter
Advocate IV
2 years ago

Did you ever figure this out?  Running into the same issue right now.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes eventually I did. The key with any visual which displays data via DirectQuery is that the viewer also belongs to the workspace where that data resides. Secondly I think that workspace needs to be on premium capacity but start by ensuring you are a viewer / member of the underlying workspace