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
3 years ago

Hello jeroenterheerdt ,

I have a similar issue as Anonymous  but my case is connected to exporting the report to png file.
I've got 2 reports connected to one dataset. However, one of the report is also connected via direct query to another data source.

When it comes to exporting in P.Automate and putting it into Send Via Email V2 method, the first report works well, but the one with Direct Query not > I receive empty visuals with the message can't display the visual'.

Could u please assist?