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.

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.

    • Josiah_Sim's avatar
      Josiah_Sim
      New Member
      3 years ago

      Hey jeroenterheerdt 

      Encountering the same issue, have a fix been deployed?

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

        yes, that was deployed. please open another issue if it still persists so we can investigate. thank you!

    • GuyDel's avatar
      GuyDel
      Frequent Visitor
      3 years ago

      Hi jeroenterheerdt ,
      I am encoutenring exactly this issue on a flow I am creating today. This is the third scenario you listed (with the symptoms described by the OP) 
       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)

      Can we expect a working fix on this?
      Thanks for your help

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

        can you please open a new issue so we can get more eyes on this?