Forum Discussion

bml123's avatar
bml123
Icon for Post Patron rankPost Patron
4 years ago
Solved

Export to file for paginated report error- integrated security in the connection string

Hi,

 

I have created a flow that runs a paginated report and export into excel spreadsheet and saves to one-drive.

 

Save a paginated report to OneDrive for Business or SharePoint Online - Power BI | Microsoft Docs

 

But I am getting the below error at 'Export to file for paginated report' stage.

 

"You have specified integrated security in the connection string for the data source. Please remove it from the connection string and try uploading the report again."

 

The report is using SQL database and it's running fine on its own but failing in the flow with the above error.

 

Please can someone help with this.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    bml123 

     Try changing the datasource settings and unchecking the "Report viewers can only access this data source with their own Power BI identities using DirectQuery." box in the "manage" menu option page. if you are using a SQL authentication, change authentication to be basic, then click sign in. 

     

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi bml123 ,

     

    Did you specify parameters for the paginated report?

    Find detailed descriptions of the parameters in the connector reference for the Power BI REST API.

    I think Power Automate will trigger a Rest API call to export paginated reports from Power BI Service.

    You may refer to offical blogs as below to learn more details.

    For reference:

    Export paginated report to file

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • bml123's avatar
    bml123
    Icon for Post Patron rankPost Patron
    4 years ago

    Hi Anonymous 

     

    I have parameters in the paginated report.  I want to run the whole report without passing any values to the parameters.  I have tried all options but still getting the same error.  Any pointers?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      The problem is with the pagainted report. The API is unable to authenticate the export using windows or microsoft account authentication. It appears to need to be mapped to a gateway or SQL authentication. 

       

      Anonymous is there anything you can do to get a resolution to this? passing a value through the identities placeholder doesn't work either. I still get the same error

      • bml123's avatar
        bml123
        Icon for Post Patron rankPost Patron
        4 years ago

        hi @sdruval,

         

        I am using SQL authentication but still not working.