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 getting an error. The report only has a table visual with a column:

I should have this output (if I do the export directly in Power Bu Service, it works fine):

 

 

Did anyone have the same issue and was able to get a solution?

 

 

 

Below it is described the steps followed:

 

1 - Set the following preview features that allows to directquery a PBI dataset:

 

2 - Connect to a PBI Dataset

 

3 - Click on the "Make changes to this model" option, add a local model and select all the tables available in the PBI dataset:

 

 

4 - Create a visual by selecting any field

 

5 - Save the report and publish it into a Premium Workspace

 

6 - Create a power automate flow that exports the report and send it by email:

 

 

 

The final result is always the same...

 

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.

15 Replies

  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    what licence type you have? some flows need to the report be a primium capacity o per user llicence or the flow itself depending in the combination. 

    • 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

    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?