Export To File for Paginated Reports via Power BI Action

[srduval]

Trying to use the new export file option that's baked into the power bi action works great for anything that doesn't have a parameter, but when I try and export a report that requires a parameter, I get a general connection failure

Error Has Occurred during report processing. My parameters are date/time in the report builder and this is what i'm passing via flow:

[

  {

    "name": "StartDate",

    "value": "2020-09-16T00:00:00.0000000"

  },

  {

    "name": "EndDate",

    "value": "2020-09-16T00:00:00.0000000"

  }

]
Anyone have a working sample or ideas as to what i'm doing wrong?

[analmei]

Hello, 

In order I can help you, can you share a screenshot of your flow and the error message?

Ana Almeida | Power Platform Support Engineer

[srduval]

Thanks @analmei 

I'm working with Sk on this issue as well. But here is the requested screenshot. Also further trial and error on my side has revealed that it is not about the parameter, the report has to be mapped to a gateway, even though it's strictly azure sql database, and a gateway is not supposed to be required to use the report, and the report renders fine within power bi service without needing to have a gateway assigned 

Sk Javul Raheman(MINDTREE LIMITED)
Support Engineer
PowerApps and MS Flow Support
Email: v-skrahe@microsoft.com
Backup Email: mtappflowomta@microsoft.com
Working hours: 6:30 PM – 3:30 AM IST