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

I have Pro license and I didn't have any issues before on creating these kind of flows. This error only comes up when I'm using a report created on top of a composite model (direct query to a PBI Dataset).

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

since you are Pro, can you please confirm that the account you use to generate the PDF has build permissions on the dataset?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi jeroenterheerdt, the account used has Admin permissions in the Premium Workspace where the Dataset is published.

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      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

        Hi jeroenterheerdt , thank you for your fast answer. I will test it again in a week and get back to you with my feedback.